| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORKDAY and holidays
Hi,
I need to have a date formula which will not ignore weekends and will take into account a list of holiday dates. WORKDAY takes care of the holiday list but ignores weekends. Is there another function that will include weekends AND holidays? p.s. any weekends within the holiday dates can be ignored. Thanks -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add no. of days to a workday to get new workday? | Excel Worksheet Functions | |||
| Holidays | Excel Worksheet Functions | |||
| Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
| Workday - Saturdays Included - Holidays Excluded | Excel Worksheet Functions | |||
| =SUM((B7+2),IF($D7>0.Workday,($D7+E$8,Holidays!$C4:$C11$),'''')) | Excel Worksheet Functions | |||
Threaded Mode
