Excel: Adding Weekdays to a Starting Date

ID: Q77799

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
Microsoft Excel for OS/2, versions 2.2 and 3.0

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