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.

=NETWORKDAYS.INTL(DATE(2026,10,1), DATE(2026,10,31), "0111111")→4

October 2026 has four Mondays.

=NETWORKDAYS.INTL(DATE(2026,10,1), DATE(2026,10,31), "1111011")→5

October 2026 has five Fridays.

FAQ

Which position is which day?

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

How do I count weekend days only?

Use "1111100", which counts Saturdays and Sundays: =NETWORKDAYS.INTL(A2, B2, "1111100").

Are the start and end dates included in the count?

Yes. Both dates are counted when they fall on the chosen weekday.

How do I count a weekday without NETWORKDAYS.INTL?

Use =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)), 2)=1)) to count the Mondays between two dates.

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