How to Count Specific Weekdays Between Two Dates in Google Sheets

To count how many times a specific day of the week falls between two dates in Google Sheets, use NETWORKDAYS.INTL with a seven-character mask that leaves only that day as a “working day”. For example, this counts the Mondays between the dates in A2 and B2, including both dates:

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

This guide explains how the mask works, how to count several days at once and how to count weekend days.

Tested in Google Sheets. On November 9, 2026 we entered the formulas on this page in Google Sheets, every weekday mask in the tables, the SEQUENCE alternative and the error cases, and compared the results with values calculated independently. How we test

How the mask works

The third argument of NETWORKDAYS.INTL can be a text of seven characters, one for each day from Monday (first) to Sunday (last). A 0 means the day is counted and a 1 means it is skipped. To count a single day, put a 0 in its position and 1 everywhere else:

Count Mask
Mondays "0111111"
Tuesdays "1011111"
Wednesdays "1101111"
Thursdays "1110111"
Fridays "1111011"
Saturdays "1111101"
Sundays "1111110"

The mask must be in quotes. Without them, Google Sheets treats 0111111 as the number 111111 and the formula returns a #NUM! error.

Example: March 2026

March 2026 starts on a Sunday and ends on a Tuesday. With A2 = 3/1/2026 and B2 = 3/31/2026:

Formula Counts Result
=NETWORKDAYS.INTL(A2, B2, "0111111") Mondays 5
=NETWORKDAYS.INTL(A2, B2, "1011111") Tuesdays 5
=NETWORKDAYS.INTL(A2, B2, "1101111") Wednesdays 4
=NETWORKDAYS.INTL(A2, B2, "1111110") Sundays 5

Months with 31 days always have three days of the week that appear five times. In March 2026 those are Sunday, Monday and Tuesday.

Count several days at once

Put a 0 in every position you want to count. For a class that meets on Mondays and Wednesdays:

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

For a term from Monday, September 7 to Friday, December 18, 2026, that returns 30 class days (15 Mondays and 15 Wednesdays).

Count weekend days

To count Saturdays and Sundays, count the last two positions:

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

March 2026 has 9 weekend days, and the whole of 2026 has 104.

Skip holidays too

NETWORKDAYS.INTL accepts a list of holidays as the fourth argument. To count the Mondays in a period, excluding Mondays that are holidays:

=NETWORKDAYS.INTL(A2, B2, "0111111", Holidays!A2:A)

See NETWORKDAYS with holidays for how to set up the holiday list.

Alternative: WEEKDAY with SEQUENCE

If you prefer a formula that spells out the day of the week, generate every date in the period with SEQUENCE and count the ones that match with WEEKDAY:

=SUMPRODUCT(--(WEEKDAY(SEQUENCE(B2-A2+1, 1, A2))=2))

By default, WEEKDAY numbers the days from 1 = Sunday to 7 = Saturday, so 2 means Monday. For March 2026 this also returns 5. The NETWORKDAYS.INTL version is shorter and easier to read; this version is useful when you want to combine the day of the week with other conditions.

Why the count can be off

The result is one too many or one too few

Both formulas count the start and end dates if they fall on the chosen day. If the period should start the day after A2, use A2+1 as the start date.

#NUM! error with SEQUENCE

The end date is earlier than the start date, so B2-A2+1 is zero or negative and SEQUENCE cannot create the list. Check the order of the dates.

The mask counts the wrong day

The mask starts on Monday, while WEEKDAY’s default numbering starts on Sunday. Mixing the two is the most common reason for counting the wrong day.

Related guides