| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get an end date for a schedule excluding Sundays?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working Days excluding Sundays | Excel Discussion (Misc queries) | |||
| Excel - list days of a month, excluding Sundays | Excel Discussion (Misc queries) | |||
| Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
| Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. | Excel Discussion (Misc queries) | |||
| Count Days excluding Sundays | Excel Worksheet Functions | |||
Threaded Mode
