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 Monday December 2019
2=WORKDAY.INTL(A1,7) = 11 Wednesday December 2019
3=WORKDAY.INTL(A1,7,1) = 11 Wednesday December 2019
4=WORKDAY.INTL(A1,-6,1) = 22 Friday November 2019
5=WORKDAY.INTL(A1,7,7) = 11 Wednesday December 2019
6=WORKDAY.INTL(A1,7,14) = 10 Tuesday December 2019

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


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