Weekday Count in Date Range

Worked example

January 1 through February 1, 2027 spans 31 days. Since January 1, 2027 is a Friday, the range contains 5 Fridays, 5 Saturdays, and 5 Sundays, but only 4 each of Monday through Thursday. After 4 full weeks, 28 days, the 3 remaining days are Friday, Saturday, and Sunday, and each of those three weekdays picks up one extra occurrence from that leftover partial week while the other four weekdays stay at 4.

Common mistakes

• Assuming every weekday appears the same number of times in any given range. Only a range that spans an exact multiple of 7 days guarantees that. Any leftover days add one extra occurrence to whichever weekdays they happen to land on.
• Forgetting that the end date itself is excluded. A range meant to include the end date entirely should use the day after it as the end date instead, or the count will come out one day short of what was intended.

Limitations

This counts weekdays only. It does not exclude holidays, so for a working-day count that excludes holidays as well, see Business Days & Work Calendar.