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.


Example

 A
1=TODAY() = Thursday 01 December 2022
2=NOW() = Thursday 01 December 2022 06:02:29
3=WORKDAY.INTL(A1,9,1) = Wednesday, 14 December, 2022 12:00 AM
4=WORKDAY.INTL(A1,9,7) = Wednesday, 14 December, 2022 12:00 AM
5=WORKDAY.INTL(A1,9,14) = Sunday, 11 December, 2022 12:00 AM

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays 9 business days after the date in cell "A1" (excluding Saturday and Sunday with an explicit argument).
4 - Displays 9 business days after the date in cell "A1" (excluding Friday and Saturday).
5 - Displays 9 business days after the date in cell "A1" (excluding just Wednesday).


Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date serial number of the current system date and time.
WORKDAY.INTL - The date 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


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