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.
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.
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