| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting Holidays from Calendar Days
Hi All,
I know how to subtract holidays from NETWORKDAYS in a formula by defining them (as in Christmas Day 25/12/2008), but I have a process that is giving me a headache. It is measured in calendar days, so at present I am doing a simple subtraction of start date cell - end date cell of process. However, I obviously cannot account for any holidays in year. Is there a formula/way of doing this? Thanks, Drew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| Add days to a date, but exclude holidays | Excel Worksheet Functions | |||
| calculating days + holidays | Excel Worksheet Functions | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
Threaded Mode
