2024-02-28 to 2024-03-06
7 elapsed days (1 full week) and 8 inclusive calendar days. This leap-year range includes February 29.
Weeks Between Dates Calculator
Calculate elapsed and inclusive days, exact weeks, full seven-day periods, and the ISO calendar weeks touched by two dates.
Direct answer
14 days = 2 full weeks and 0 days
This uses 14 elapsed days. Counting both the start and end dates gives 15 inclusive calendar days, with 3 ISO calendar weeks touched, including any partial Monday-to-Sunday weeks at either end.
- Start date
- 2026-11-13
- End date
- 2026-11-27
- Elapsed days
- 14 days
- Full weeks
- 2 weeks
- Exact weeks
- 2 weeks
- Rounded-up weeks
- 2 weeks
- Inclusive calendar days
- 15 days
- ISO calendar weeks touched
- 3 weeks
Copy this result
Copy the result or a shareable URL that keeps this start and end date.
How weeks between dates are counted
- Elapsed days
- End date minus start date. The start date is day 0, so May 3 to May 18 is 15 elapsed days.
- Inclusive calendar days
- Elapsed days plus 1. Use this when both the start and end dates should count.
- Full and rounded-up weeks
- A full week is 7 elapsed days. Rounded-up weeks count full seven-day periods plus one more if any days remain: 14 days is 2 weeks; 15 days rounds up to 3 weeks. Zero elapsed days stays 0. This is not a count of ISO calendar weeks.
- ISO calendar weeks touched
- This counts distinct Monday-to-Sunday ISO weeks containing at least one selected date, including partial weeks at the boundaries.
This is a calendar-duration calculation. It does not count business days or exclude holidays.
Excel and Google Sheets formulas
Put the start date in A2 and the end date in B2 as real spreadsheet dates. These formulas use the same elapsed-day method as the calculator.
- Elapsed days
=B2-A2- Full weeks
=QUOTIENT(B2-A2,7)- Remaining days
=MOD(B2-A2,7)- Inclusive calendar days
=B2-A2+1
If B2 is before A2, swap the dates first. ISO calendar weeks touched is a separate Monday-to-Sunday count, not the elapsed duration divided by seven.
Worked weeks-between examples
2025-12-29 to 2026-01-12
14 elapsed days (2 full weeks) and 15 inclusive calendar days. Crossing New Year does not change the duration formula.
The calculator uses UTC calendar-date arithmetic and is tested across both leap-day and New Year boundaries, so browser locale and daylight-saving offsets do not change the elapsed-day count.
FAQ
What is the difference between elapsed and inclusive days?
Elapsed days use end date minus start date, so the start is day 0. Inclusive days count both boundary dates and equal elapsed days plus 1.
What does rounded-up weeks mean?
Divide elapsed days by 7 and round up only if there is a remainder. For example, 7 days is 1 week, 8 days rounds up to 2 weeks, and 14 days remains 2 weeks. The separate ISO calendar weeks touched result counts distinct Monday-to-Sunday weeks instead.
Does this calculator count business days or holidays?
No. It measures calendar duration only. Weekends and holidays are included like any other calendar day.
Does crossing a year or leap day change the calculation?
No. Valid calendar dates are compared directly, so New Year boundaries and February 29 are included automatically.