Add business days to a date changing the days of the weekend
You can add business days to an existing date by using the WORKDAY.INTL function.
This function will default to excluding Saturdays and Sundays.
Example
|
1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays 9 business days after the date in cell "A1" (excluding Saturday and Sunday with an explicit argument).
4 - Displays 9 business days after the date in cell "A1" (excluding Friday and Saturday).
5 - Displays 9 business days after the date in cell "A1" (excluding just Wednesday).
Built-in Functions
<A HREF="../functions/today-function.htm"><U>TODAY</U></A> - The date serial number representing today's date.
<A HREF="../functions/now-function.htm"><U>NOW</U></A> - The date serial number of the current system date and time.
<A HREF="../functions/workday-intl-function.htm"><U>WORKDAY.INTL</U></A> - The date serial number that is a given number of working days before or after a date.
Related Formulas
Subtract business days from a date changing the days of the weekend
Add business days to a date
Add business days to a date excluding public holidays
Add days to a date including weekends
Add days to a date not landing on a weekend
Number of business days between 2 dates
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top