Excel Formula - Add business days to a date excluding public holidays

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 Thursday January 2020
2	=NOW() = 02 Thursday January 2020
3	=TODAY() = 02 Thursday January 2020
4	=WORKDAY(A1,2) = 06 Monday January 2020
5	=WORKDAY(A1,4) = 08 Wednesday January 2020
6	=WORKDAY(A1,6) = 10 Friday January 2020
7	=WORKDAY(A1,5,A4:A6) = 14 Tuesday January 2020

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