# 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 10 September 2024 2 =NOW() = Tuesday 10 September 2024 10:51:43 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.