Add business days to a date excluding public holidays

You can add a certain number of business days to an existing date by using the WORKDAY function.
Cell "A1" displays the date
Cell "A2" displays the date and time.
Cell "A3" display the date formatted in long date format
Cell "A4:A6" contain the business days that you want to exclude.
Cell "A7" displays 5 business days after the date in A1 excluding the 3 addition calendar holidays.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02 Monday December 2019
2=NOW() = 02 Monday December 2019
3=TODAY() = 02 Monday December 2019
4=WORKDAY(A1,2) = 04 Wednesday December 2019
5=WORKDAY(A1,4) = 06 Friday December 2019
6=WORKDAY(A1,6) = 10 Tuesday December 2019
7=WORKDAY(A1,5,A4:A6) = 12 Thursday December 2019

Built-in Functions

TODAY - The serial number representing today's date.
WORKDAY - (WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL - The serial number that is a given number of working days before or after a date.
WEEKDAY - The day of the week for a given date.


Related Formulas

Add business days to a date
Add business days to a date changing the days of the weekend
Add days to a date including weekends
Add days to a date not landing on a weekend
Number of business days between 2 dates


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