Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to skip holidays
Hi,
I have a holiday list set up, and a formula that works out the projected completion date of a job in the format dd/mm/yyyy hh:mm. How can i add to the formula so that if a day within the holiday list is predicted it skips to a day after (which is not a holiday), and still gives an accurate date/time e.g Predicted time to complete is say 4 hours start date/time: 28/12/2007 16:40 Finish time should be: 31/12/07 11:40 (The formula takes is to take into account working day (9-5 mon-fri) Please help! Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Workdays-Holidays-adjustments | Excel Worksheet Functions | |||
Skip holidays falling between two dates | Excel Worksheet Functions | |||
Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
Skip the Holidays 2 | Excel Discussion (Misc queries) | |||
Skip the holidays | Excel Discussion (Misc queries) |