Here is a formula to calculate the number of weekdays between two dates, inclusive. That is, the number of weekdays between Monday and the next day are 2. I am using this for a schedule spreadsheet where I need to see working days.

In this example, cell A2 contains the earlier date and B2 contains the later date.

=MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5

If you don't want it to be inclusive you can remove "+1".

This, of course, does not take holidays into account.

In this example, cell A2 contains the earlier date and B2 contains the later date.

=MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5

If you don't want it to be inclusive you can remove "+1".

This, of course, does not take holidays into account.

## Comment