|
Posted to microsoft.public.excel.misc
|
|
|
How to get an end date for a schedule excluding Sundays?
Hi,
Look into CPearson web
http://www.cpearson.com/excel/betternetworkdays.aspx
"Taner" wrote:
I am making a schedule using Excel. I have the start date and the number of
days the employees will be working. I want to get the end date, but exclude
Sundays only. The employees work 6 days a week.
For example: Start Date: 4/1/2010
Number of working days: 7
The End Date would be: 4/8/2010
If I use WORKDAY it bases it off of Mon-Fri.
Not sure exactly the best way to go about this. Any help is greatly
appreciated!
Thanks
|