MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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").

Any suggestions???


Posted by Mark W. on March 16, 2001 8:17 AM

JAF, take a look at the WORKDAY() function.

Posted by JAF on March 16, 2001 8:37 AM

Boy - do I feel stupid!!!!! :-)