Add business days to a date

You can add or subtract business days (defined as Monday to Friday) to an existing date by using the WORKDAY.INTL function.
Cell "A1" displays a date.
Cell "A2" displays 4 business days after that date.
Cell "A3" displays 4 business days after that date for Excel 2007.
Cell "A4" displays 6 business days before that date.
Cell "A5" displays 6 business days before that date for Excel 2007.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 01 Thursday August 2019
2=WORKDAY.INTL(A1,4) = 07 Wednesday August 2019
3=WORKDAY(A1,4) = 07 Wednesday August 2019
4=WORKDAY.INTL(A1,-6) = 24 Wednesday July 2019
5=WORKDAY(A1,-6) = 24 Wednesday July 2019

Built-in Functions

TODAY - The serial number representing today's date.
WORKDAY.INTL - (2010) The serial number that is a given number of working days before or after a date.
WORKDAY - (WORKDAY.INTL) The serial number that is a given number of working days before or after a date.


Related Formulas

Add business days to a date excluding public holidays
Add business days to a date changing the days of the weekend
Add days to a date including weekends
Add days to a date not landing on a weekend


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top