Number of business days between 2 dates

You can return the number of business days between two dates by using the NETWORKDAYS.INTL function.
This function will include both the "start_date" and the "end_date" so you need to minus 1.
This function will ignore Saturdays and Sundays by default.


 A
1=TODAY() = Tuesday 01 October 2024
2=NOW() = Tuesday 01 October 2024 06:08:01
3=NETWORKDAYS.INTL(A1, A1) = 1
4=NETWORKDAYS.INTL(A1, A1)-1 = 0
5=NETWORKDAYS.INTL(A1, A1+1)-1 = 1
6=NETWORKDAYS.INTL(A1, A1+2)-1 = 2
7=NETWORKDAYS.INTL(A1, A1+3)-1 = 3
8=NETWORKDAYS.INTL(A1, A1+4)-1 = 3
9=NETWORKDAYS.INTL(A1, A1+5)-1 = 3
10=NETWORKDAYS.INTL(A1, A1+6)-1 = 4
11=NETWORKDAYS.INTL("01/01/2020", "20/01/2020")-1 = 13

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 the number of business days between that date and 1 day after.
4 - Displays the number of business days between that date and 2 days after.
Cell "A10" displays the number of business days between 1 January 2020 and 20 January 2020.


Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date serial number of the current system date and time.
NETWORKDAYS.INTL - The total number of working days between two dates excluding weekends and holidays.


Related Formulas

Add business days to a date
Number of business days in a particular month
Number of business days left in the current month
Number of business days left in the current year
Number of business days that have passed in the current month


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