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".
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.
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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top