Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

Add to a date a number of WORKING Days

Posted by JAF on March 16, 2001 8:03 AM
Hiya

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.

Examples:
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???


JAF


Re: Add to a date a number of WORKING Days

Posted by Mark W. on March 16, 2001 8:17 AM
JAF, take a look at the WORKDAY() function.

Re: Add to a date a number of WORKING Days

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

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.