Counting specific weekdays is useful for schedules (how many Tuesday classes in a term), payroll (how many Fridays this year) and planning (how many Saturdays before a wedding).
How to use the Day Counter: Count Weekdays Between Dates
- Start date
- End date (included)
- Weekday to count
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter the start and end dates (both counted), and choose the weekday to count.
Inputs explained
| Field | What to enter |
|---|---|
| Start date | A date |
| End date (included) | A date |
| Weekday to count | Choose one: Sunday, Monday, Tuesday, Wednesday … |
What each result means
- Days in range = [End date (included)] – [Start date] + 1
- Number of the chosen weekday = (max(floor((([End date (included)]) – (([Start date]) + mod(([Weekday to count]) – weekday([Start date]), 7)))÷7) + 1, 0))
- Weekdays (Mon–Fri) = workdays([Start date], [End date (included)] + 1)
- Weekend days = [Days in range] – [Weekdays (Mon–Fri)]
- Saturdays = (max(floor((([End date (included)]) – (([Start date]) + mod((6) – weekday([Start date]), 7)))÷7) + 1, 0))
- Sundays = (max(floor((([End date (included)]) – (([Start date]) + mod((0) – weekday([Start date]), 7)))÷7) + 1, 0))
Formula
Count of a weekday = the number of days in the range that fall on it
First match = start + (weekday − start weekday) mod 7; count = floor((end − first match) ÷ 7) + 1
Worked example
Inputs: Start date: 2026-10-25; End date (included): 2027-04-23; Weekday to count: Friday.
Results: Days in range = 181; Number of the chosen weekday = 26; Weekdays (Mon–Fri) = 130; Weekend days = 51; Saturdays = 25; Sundays = 26.
Frequently asked questions
How many Fridays are in a year?
52, or 53 if the year starts on a Friday (or on a Thursday in a leap year).
How do I count days between two dates including both?
End − start + 1.
How many weekend days are in a year?
104 or 105 (106 in some leap years).
Guides on this topic
- How to Count Days Between Dates (Inclusive, Leap Years and Business Days): Subtract, then decide whether to add 1. A clear guide to counting days, leap years, working days and adding days or months to a date, with worked examples.