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 a date
Cell "A2" display the date formatted in long date format
Cell "A3" is the number of days (excluding Saturday and Sunday) that you want to add.
Cell "A4:A6" contain the days that you want to exclude in addition to the Saturdays and Sundays.
Cell "A7" displays 5 business days after the date in A1 excluding the 3 addition calendar holidays.

 A
1=TODAY() = 31/05/2019
2=A1 = Friday, May 31, 2019
35
4=WORKDAY(A1,2) = Tuesday, June 04, 2019
5=WORKDAY(A1,4) = Thursday, June 06, 2019
6=WORKDAY(A1,6) = Monday, June 10, 2019
7=WORKDAY(A1,A3,A4:A6) = Wednesday, June 12, 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 - (2010) 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