Weeks between dates calculator
Wondering how many weeks are between two dates? Pick any two dates and this calculator shows the number of complete weeks, plus any leftover days.
Something look wrong or missing? Tell us via the contact page.
How the weeks between dates calculator works
Enter two dates and this calculator converts the gap into full 7-day weeks plus any remaining days — for example, a 10-day gap is 1 week and 3 days. It is handy for tracking pregnancy weeks, project sprints, rental periods, or age in weeks.
A “week” here means any 7 consecutive days, not a Monday-to-Sunday calendar week, so the count works the same wherever your week starts.
full weeks = floor(total days ÷ 7)
Worked examples
Each example below counts the end date as excluded — the default. Tick “Include end date” in the tool to add one day to any of these counts.
Worked example: 6 January 2025 to 17 March 2025
The gap between 6 January 2025 and 17 March 2025 is exactly 10 weeks. The two dates are 70 days apart, and 70 ÷ 7 = 10 weeks with no remainder.
The method is always the same: count the exact calendar days between the two dates first, then divide by 7. Whole weeks are the complete 7-day blocks; any leftover days are shown separately by the calculator above.
Common mistakes when counting weeks between dates
- Counting both endpoints: adding the start and end day into the count inflates the result by a day. A date difference measures the distance between the dates, not the number of dates touched.
- Assuming every month has 30 days: February and the 31-day months make hand counts drift by several days over a long gap — exact calendar counting avoids this.
- Forgetting leap years: any period that includes 29 February has one extra day, which can push a result across a whole-week boundary.
Weeks between dates FAQ
Is a week Monday to Sunday here?
No. A week means any 7 consecutive days, so the result is the same regardless of which weekday your range starts on.
What happens to the leftover days?
They are shown separately. A 10-day gap, for example, is reported as 1 full week and 3 extra days.
Does the order of the dates matter?
No — the tool counts the absolute gap between the two dates either way round.
How many weeks are between two dates?
Enter the two dates above — the calculator divides the total days by 7 and reports full weeks plus the remaining days. A 45-day gap, for example, is 6 weeks and 3 days.
How to calculate weeks between two dates?
Count the days between the two dates and divide by 7. The whole-number part is full weeks and the remainder is extra days. Example: 45 days apart is 6 full weeks and 3 days.
What is the formula to find weeks between dates?
Full weeks = floor((end date − start date in days) ÷ 7). In plain math: divide the total days by 7 and take the whole number; whatever is left over is extra days.
How to calculate weeks between two dates manually?
Count the days between the dates on a calendar (or subtract the earlier date from the later one), divide by 7, and drop the fraction. Example: Jan 1 to Feb 15 is 45 days; 45 ÷ 7 = 6 remainder 3, so 6 full weeks.
How do you calculate months and weeks between two dates?
First take the full calendar months between the dates, then convert the leftover days into weeks: leftover weeks = leftover days ÷ 7 (whole number). Example: Jan 10 to Apr 5 is 2 full months plus 26 days, which is 3 weeks and 5 days — so 2 months, 3 weeks, 5 days.
How to find weeks between two dates in Excel?
If the start date is in A1 and the end date in B1, use =INT((B1-A1)/7) for full weeks. Make sure both cells are formatted as dates first.
What is the Excel formula for number of weeks between two dates?
=INT((B1-A1)/7) gives complete weeks between the dates in A1 and B1. Use =(B1-A1)/7 instead if you want fractional weeks.
How to calculate weeks between two dates in Google Sheets?
The same as Excel: =INT((B1-A1)/7) for full weeks. Google Sheets also accepts =DATEDIF(A1,B1,"D")/7 for fractional weeks.
How to use DATEDIF function for weeks between dates?
DATEDIF has no weeks unit, so get days first: =DATEDIF(A1,B1,"D")/7 gives fractional weeks, and =INT(DATEDIF(A1,B1,"D")/7) gives full weeks. DATEDIF needs the start date before the end date.
How to calculate weeks between two dates in JavaScript?
Use Math.floor((date2 - date1) / (7 * 24 * 60 * 60 * 1000)). Subtracting two Date objects gives milliseconds; dividing by the milliseconds in a week and flooring the result gives full weeks.
How to calculate weeks between two dates in Python?
With datetime.date objects, use (date2 - date1).days // 7. Example: (date(2026,2,15) - date(2026,1,1)).days // 7 equals 6.
What is the SQL query to get number of weeks between two dates?
In SQL Server: DATEDIFF(week, start_date, end_date). In MySQL: FLOOR(DATEDIFF(end_date, start_date) / 7). Note that DATEDIFF counts date boundaries, so verify the exact behavior on your database.
Should I include the end date in the count?
It depends on what you are measuring. Include the end date for countdowns and “how long until” ranges — the same convention hotels use when they count nights — and leave it out for elapsed time between two dates, which is the default. The “Include end date” checkbox above switches between the two in one click.
Do weekends count in the weeks between two dates?
By default, yes: a week is 7 consecutive days, weekends included. If you only care about working days, tick “Exclude weekends” and the calculator shows the weekday/weekend split plus a weekdays-only figure in weeks and days.
Do the start and end dates count when calculating weeks between dates?
The standard date difference excludes the start date and counts the days elapsed up to the end date — the same convention used for hotel nights. If you need both endpoints included (for example, counting every day of an event), add one day to the result.
How many weeks are in a year?
A calendar year has 52 full weeks plus 1 extra day (2 extra days in a leap year), which is 52.14 weeks on average. That is why a date falls on a different weekday the following year, and why some years have a 53rd week in ISO week numbering.