Excel: Adding Weekdays to a Starting Date

ID: Q77799


The information in this article applies to:


SUMMARY

The following formula calculates a new date in Microsoft Excel by adding a specific number of weekdays to a starting date:


   =startdate+numdays+INT((numdays+WEEKDAY(startdate)-2)/5)*2 


In the above formula, "startdate" is the starting date and "numdays" is the number of weekdays you want to add. For example, if you want to add two weekdays to a Thursday, the above formula yields the date of the following Monday. If numdays is a negative number, the formula subtracts that many weekdays from startdate.

Startdate must occur on a weekday. If startdate occurs on a weekend, the calculation may not be accurate.


MORE INFORMATION

For more information on calculating dates, query on the following words:


   excel and calculate and date 

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 22, 1999