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() = Friday 29 November 2024
2	=NOW() = Friday 29 November 2024 11:44:05
3	=WORKDAY.INTL(A1, 9, 1) = Thursday, 12 December, 2024 12:00 AM
4	=WORKDAY.INTL(A1, 9, 7) = Wednesday, 11 December, 2024 12:00 AM
5	=WORKDAY.INTL(A1, 9, 14) = Monday, 09 December, 2024 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