Add business days to a date

You can add 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 6 business days after that date.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02 Monday December 2019
2=WORKDAY.INTL(A1,6) = 10 Tuesday December 2019

Built-in Functions

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


Related Formulas

Subtract business days from a date
Add business days to a date changing the days of the weekend
Add business days to a date excluding public holidays
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