See how to find the school evaluation end date with the WORKDAY function given a start date, number of workdays and non-included days. See how to have a dynamic range using the Excel List (2003) or Excel Table (2007) feature.
i just started a new job and i was asked to schedule a roster for employees for 2010. Is there any video that you teach on this? please advise if I can use excel for this? I would greatly appreciate your input.
How do I determine the Monday date of the week does the given date belong to ? ex... Monday date of 12/01/2009 (tues) is 11/30/2009 (Mon)....Is there such formula?
You are welcome!
ExcelIsFun 1 year ago
Thanks it helped for stock sales. The table also helped to copy and paste without changing the holidays. Nicely done
keeee691 1 year ago
I do not have any videos on scheduling. If you have a specific Excel question you might try posting it to the Mr Excel Message Board:
mrexcel[dot]com/forum
THE smartest Excelers in the world hand out at this site.
I made a video about this siye. If you search YouTube for "Post Question at Mr Excel", you will find the video.
ExcelIsFun 2 years ago
hi mike,
i just started a new job and i was asked to schedule a roster for employees for 2010. Is there any video that you teach on this? please advise if I can use excel for this? I would greatly appreciate your input.
Thanks
Binoj
cpbp09 2 years ago
I don't understand. If you are given 11/30/2009 (Mon), you arleady have the date.
ExcelIsFun 2 years ago
How do I determine the Monday date of the week does the given date belong to ? ex... Monday date of 12/01/2009 (tues) is 11/30/2009 (Mon)....Is there such formula?
bubbamufaka 2 years ago
I am glad that you like it!
ExcelIsFun 2 years ago
Nice!
drcloak 2 years ago