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".

1=TODAY() = 02 Thursday January 2020
2=WORKDAY.INTL(A1,6) = 10 Friday January 2020

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

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