ThisCalculator

Date and time

Weeks Between Dates: Formula and Calculator

Updated · Standard formula, shown below

Weeks between dates 7.00 weeks
Elapsed days
49 days
Result
Start date (days from epoch)
20000 days
You entered
End date (days from epoch)
20049 days
You entered

Weeks Between Dates: Formula and Calculator

Calculate the number of weeks between two dates by entering a start date and an end date. This calculator returns the elapsed time in days and weeks, including any remaining days, using the standard seven-day week.

Formula

Elapsed weeks are the number of elapsed days divided by seven:

Weeks = (End date − Start date) ÷ 7

  • Start date is the earlier date, represented as a whole-day number.
  • End date is the later date, represented in the same way.
  • Elapsed days is the difference between those date numbers, measured in days.
  • Weeks is the elapsed-day total divided by 7. The calculator rounds this output to two decimal places.

The calculator’s date inputs are day counts so the calculation can be expressed numerically: use the same calendar-day numbering convention for both dates. For an ordinary date calculator, you would select the dates on a calendar; the day count is simply an internal representation, not a date format you need to calculate by hand.

Worked Example

Using the calculator’s default values, the start day is 20,000 and the end day is 20,049.

  1. Find the elapsed days: 20,049 − 20,000 = 49 days.
  2. Divide by seven: 49 ÷ 7 = 7 weeks.
  3. Rounded to two decimal places, the result is 7.00 weeks.

The secondary output is 49 days. Because the example is exactly seven weeks long, there are no leftover days.

How to Calculate Weeks Between Dates

For two calendar dates, count the elapsed days between them, then divide by seven. A date subtraction tool, spreadsheet, or calendar can provide the day difference; the week conversion is the same in every case.

  1. Choose the start and end dates.
  2. Make sure both dates use the same calendar system and time-zone convention if times are involved.
  3. Subtract the start from the end to get elapsed days.
  4. Divide by 7. Keep the decimal for a fraction of a week, or report full weeks and leftover days.

For example, 26 elapsed days is 26 ÷ 7 = 3.714…, or about 3.71 weeks. It is also 3 full weeks and 5 days. The decimal and the weeks-plus-days form describe the same interval in different ways.

Elapsed Weeks, Calendar Weeks, and Counting Both Dates

“Weeks between dates” can refer to more than one counting convention. The formula above measures elapsed time: the start date is the starting point, and the end date is reached after the stated number of days. If two dates are exactly seven days apart, the elapsed duration is one week.

Inclusive counting instead counts both calendar dates as days in a list or schedule. If a period runs from Monday through Sunday and both endpoints are included, that is seven named dates and spans six elapsed days from midnight at the start of Monday to midnight at the start of Sunday. This distinction matters for event schedules, attendance counts, and date ranges. State whether your answer is an elapsed duration or an inclusive count.

A calendar week is a separate idea: it is often a named span such as Monday through Sunday, or Sunday through Saturday, depending on the calendar convention. Two dates can be in different calendar weeks even when fewer than seven days separate them. If you need the number of week boundaries crossed, count those boundaries instead of dividing elapsed days by seven.

Partial Weeks, Times, and Date Formats

Dividing days by seven gives a fractional week. You can round it to a chosen number of decimal places, but rounding changes precision, not the underlying duration. For a clearer everyday answer, report whole weeks plus remaining days—for example, 18 days is 2 weeks and 4 days.

If the dates include times, decide whether the question is about full elapsed periods of 24 hours or calendar dates. A time-zone change can make a local calendar day shorter or longer than 24 hours, while ordinary date subtraction treats dates as whole calendar days. For exact elapsed hours, subtract timestamps using a consistent time-zone basis and convert hours to days before dividing by seven.

Use an unambiguous date format when entering or sharing dates. Numeric formats such as 04/05/2026 can mean April 5 or May 4 depending on locale. Writing the month name, or using a clearly specified year-month-day format, helps avoid reversing the dates.

Common Mistakes and Limits

  • Counting endpoints inconsistently: elapsed time excludes the starting instant as a completed day; inclusive date counts include both named dates.
  • Confusing weeks with weekdays: a week always has seven calendar days, but the number of working days depends on weekends and holidays.
  • Rounding too early: calculate with the full day difference, then round the final week result.
  • Reversing dates: an end date earlier than the start produces a negative result, which may be valid when measuring backward but is usually an input error for a forward interval.
  • Ignoring time zones: date-only calculations do not describe exact elapsed hours when timestamps or clock changes are relevant.

This calculation does not determine business weeks, pay periods, school terms, or the number of named calendar weeks touched by a date range. Those questions require a separate rule about weekends, holidays, week starts, or inclusion of endpoints.

Frequently Asked Questions

How many weeks are between two dates?
Subtract the earlier date from the later date to get elapsed days, then divide by 7. For example, 35 elapsed days equals 5 weeks.

How do I calculate weeks and days between dates?
Divide the elapsed-day total by 7. The quotient is the number of full weeks, and the remainder is the leftover days. For 24 days, that is 3 weeks and 3 days.

Do I count the start date and end date?
For elapsed time, subtract the dates; do not add an extra day just because both dates are shown. Add one only when the task explicitly asks for an inclusive count of calendar dates.

Can the answer be a decimal number of weeks?
Yes. Divide the day difference by 7 and keep the decimal, such as 10 days ÷ 7 = about 1.43 weeks. Alternatively, express it as 1 week and 3 days.

Why does my result differ from a calendar’s week count?
A calendar may count week rows or week boundaries, while the formula measures elapsed days. The results differ when the dates fall in different calendar weeks but are less than seven days apart.

Related

Formula used
in start | Start date (days from epoch) | days | 20000 | 0
in end | End date (days from epoch) | days | 20049 | 0
out weeks | Weeks between dates | weeks | (end - start) / 7 | 2
out days | Elapsed days | days | end - start | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.