Dates & Time

Excel formula for Count a specific weekday in a date range

Count how many Mondays (or any single weekday) fall between two dates.

Copy this formula

=NETWORKDAYS.INTL(A2, B2, "0111111")

How the formula works

NETWORKDAYS.INTL takes a 7-character weekend string (Mon–Sun) where 1 = non-working. Setting every day to 1 except the one you want counts just that weekday across the range.

Examples

=NETWORKDAYS.INTL(A2, B2, "1011111")→4

Counts Tuesdays in the range.

FAQ

Which position is which day?

The string runs Monday→Sunday. Put 0 at the weekday you want to count and 1 everywhere else.

Related formulas

Count working days between dates Get the day of the week

Functions used

NETWORKDAYS.INTL WEEKDAY

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free