| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating three working days before a date
I am trying to work out the formula for the above. I know there is
the function NETWORKDAYS(), and upon searching this newsgroup I have seen messages (one quite recent) for working out the number of working days between two days. But I need to do it the other way round - give Excel a date and get it to display another date three working days before that. It would also be useful if I could put in a list of bank holidays and other "working day" exceptions somewhere in the sheet and have the formula take these into account too. Could anyone point me in the right direction? Is it NETWORKDAYS I need, or a different formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
| Calculating Working Days - Department of Pathology | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating Working Days | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
