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

You can add or subtract business days to an existing date by using the WORKDAY.INTL function.
This function will default to excluding Saturdays and Sundays.
Cell A1 displays a date
Cell A2 displays 7 business days after that date (excluding Saturday and Sunday)
Cell A3 displays 7 business days after that date (excluding Saturday and Sunday with explicit argument)
Cell A4 displays 6 days before that date (excluding Saturday and Sunday)
Cell A5 displays 7 business days after that date (excluding Friday and Saturday)
Cell A6 displays 7 business days after that date (excluding just Wednesday)
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02 Sunday February 2020
2=WORKDAY.INTL(A1,7) = 11 Tuesday February 2020
3=WORKDAY.INTL(A1,7,1) = 11 Tuesday February 2020
4=WORKDAY.INTL(A1,-6,1) = 24 Friday January 2020
5=WORKDAY.INTL(A1,7,7) = 11 Tuesday February 2020
6=WORKDAY.INTL(A1,7,14) = 10 Monday February 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.
WORKDAY - (WORKDAY.INTL) The serial number that is a given number of working days before or after a date.


Related Formulas

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


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