Add business days to a date

You can add business days to an existing date by using the WORKDAY.INTL function.
This function will ignore Saturdays and Sundays by default.


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays the date that is 7 business days after the date in cell "A1".
Cell "A4" displays the date that is 21 business days before the date in cell "A1".

 A
1=TODAY() = Wednesday 02 September 2020
2=NOW() = Wednesday 02 September 2020 08:55:08
3=WORKDAY.INTL(A1,7) = Friday, 11 September, 2020 12:00 AM
4=WORKDAY.INTL(A1,21) = Thursday, 01 October, 2020 12:00 AM

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
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 not landing on a weekend
Number of business days between 2 dates


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