Microsoft KB Archive/77799

{|
 * width="100%"|

Excel: Adding Weekdays to a Starting Date

 * }

-

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, &quot;startdate&quot; is the starting date and &quot;numdays&quot; 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 :

Technology :