Add business days to a date changing the days of the weekend

You can add business days to an existing date by using the WORKDAY.INTL function.
This function will default to excluding Saturdays and Sundays.
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 9 business days after the date in cell "A1" (excluding Saturday and Sunday with an explicit argument).
Cell "A4" displays 9 business days after the date in cell "A1" (excluding Friday and Saturday).
Cell "A5" displays 9 business days after the date in cell "A1" (excluding just Wednesday).

 A
1=TODAY() = Tuesday 02 June 2020
2=NOW() = Tuesday 02 June 2020 07:30:34
3=WORKDAY.INTL(A1,9,1) = 15 Monday June 2020
4=WORKDAY.INTL(A1,9,7) = 15 Monday June 2020
5=WORKDAY.INTL(A1,9,14) = 13 Saturday June 2020

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 changing the days of the weekend
Add business days to a date
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
Number of business days between 2 dates


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