Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding working days
From the same family as NETWORKDAYS():
WORKDAY() You may have to format the result as Date -- Kind regards, Niek Otten Microsoft MVP - Excel "TheRook" wrote in message ... |I am wanting to calculate an end date from a start date say 1/12 + 7 days = | 8/12 but if 2/12 was classed as an holiday the the end date would be 9/12 | | A have previously used networkdays using holidays as non working days but | obviously this is to calculate from a start date to an end date, and not to | prodicte an end date. | | anyone any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
adding only working days to dates | Excel Discussion (Misc queries) | |||
Adding Working Days to a Formula | Excel Discussion (Misc queries) | |||
Adding only working days | Excel Programming |