Add to a date a number of WORKING Days
Posted by JAF on March 16, 2001 8:03 AM
I'm sure that there is some simple logic that will do what I need, but it's making my head spin.
What I need is, in essence, the reverse of Excel's NETWORKDAYS function. I have a date in Column A and a number of days in Column B. Column C needs to return the date that is the number of working days (ie excluding weekends and specified public holiday dates) shown in Column B from the start date in Column A.
01 Mar 2001 - 2 working days - 05 Mar 2001
07 Mar 2001 - 8 working days - 19 Mar 2001
The examples above don't take into account any public holiday dates - these are stored on a hidden worksheet in a named range ("PublicHolidays").