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.
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 the number of business days between that date and 1 day after.
Cell "A4" 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.

 A
1=TODAY() = Wednesday 15 July 2020
2=NOW() = Wednesday 15 July 2020 14:28:08
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 = 2
8=NETWORKDAYS.INTL(A1,A1+4)-1 = 2
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

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The 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


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