Subtract business days from a date changing the days of the weekend

You can subtract business days from an existing date by using the WORKDAY.INTL function.
This function will default to excluding Saturdays and Sundays.


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays 9 business days before the date in cell "A1" (excluding Saturday and Sunday with an explicit argument).
Cell "A4" displays 9 business days before the date in cell "A1" (excluding Friday and Saturday).
Cell "A5" displays 9 business days before the date in cell "A1" (excluding just Wednesday).

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
3=WORKDAY.INTL(A1,-9,1) = 19 Tuesday April 2022
4=WORKDAY.INTL(A1,-9,7) = 18 Monday April 2022
5=WORKDAY.INTL(A1,-9,14) = 21 Thursday April 2022

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
WORKDAY.INTL - The serial number that is a given number of working days before or after a date.


Related Formulas

Add business days to a date changing the days of the weekend
Subtract business days from a date
Subtract business days from a date excluding public holidays
Number of business days between 2 dates


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top