How the days between dates are counted
The calculator counts calendar days from the start date to the end date. For example, from Monday to the next Monday is 7 days. Weekdays and weekend days add up to the total, and with the end date included the end day is counted as well.
Counting down to a holiday? Try a holiday countdown or make your own countdown.
Days between dates: worked examples for 2027
| Dates | Days | Weekdays | Weeks |
|---|---|---|---|
| Start to end of the year | 364 | 260 | 52 weeks, 0 days |
| New Year to the 4th of July | 184 | 131 | 26 weeks, 2 days |
| New Year to Christmas | 358 | 256 | 51 weeks, 1 day |
| Valentine's Day to Halloween | 259 | 185 | 37 weeks, 0 days |
| March 1 to September 1 (six months) | 184 | 132 | 26 weeks, 2 days |
| One year, January 1 to January 1 | 365 | 261 | 52 weeks, 1 day |
Frequently asked questions
How do I count the days between dates?
Pick a start date and an end date. The day counter shows the number of days between the dates straight away, plus the weeks, weekdays and weekend days.
Does the count include the end date?
By default it counts the days from the start date up to the end date, which is the same as the number of nights in between. Tick "Include the end date" to add one, for example when counting the days of a trip including the last day.
Are public holidays removed from the weekday count?
No. Weekdays are Monday to Friday. Public holidays vary by country, state and employer, so subtract any that apply to you.
Does it handle leap years?
Yes. February 29 is counted in leap years.
How do I count the days between dates in Excel or Google Sheets?
Put the dates in two cells and subtract: =B1-A1, or use =DAYS(B1,A1). Both give the same number as this day counter without the end date. Add 1 to include the end date. For weekdays only, use =NETWORKDAYS(A1,B1), which counts both the start and end dates.
How many weeks are between two dates?
Divide the number of days by seven. The day counter shows the whole weeks and the days left over under the result.