Days Between Dates Calculator

Days Between Dates is evaluated from Start Date, End Date and Include End Date in Count. The calculation reports Total Days, Complete Weeks and Remaining Days.

Results

Thanks — we’ve logged this for review.

About the Days Between Dates Calculator

Days Between Dates is treated here as a quantitative relation between Start Date, End Date and Include End Date in Count and Total Days, Complete Weeks, Remaining Days and Approx. Months.

The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.

Formula basis:
Days = (End date - Start date) in milliseconds / 86,400,000 ms/day
If 'Include End Date' = Yes: add 1 day
Complete weeks = floor(days / 7)
Remaining days = days mod 7
Approx. months = days / 30.44

Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.

Formula & How It Works

The calculation applies the following relations exactly as recorded in the metadata:

Days = (End date - Start date) in milliseconds / 86,400,000 ms/day
If 'Include End Date' = Yes: add 1 day
Complete weeks = floor(days / 7)
Remaining days = days mod 7
Approx. months = days / 30.44

Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.

Worked Examples

Example 1: January 1 to December 31, 2024 (full year, include end)

Inputs

start_date: 2024-01-01 end_date: 2024-12-31 include_end: Yes
Total Days: 366 days. Complete Weeks: 52 weeks. Remaining Days: 2 days. Approx. Months: 12 months

With Start Date = 2024-01-01, End Date = 2024-12-31 and Include End Date in Count = Yes as the stated inputs, the result is Total Days = 366 days, Complete Weeks = 52 weeks and Remaining Days = 2 days. Each value corresponds to the declared output fields.

Example 2: 30-Day Rental Notice: Mar 15 to Apr 14, 2025

Inputs

start_date: 2025-03-15 end_date: 2025-04-14 include_end: Yes
Total Days: 31 days. Complete Weeks: 4 weeks. Remaining Days: 3 days. Approx. Months: 1 months

With Start Date = 2025-03-15, End Date = 2025-04-14 and Include End Date in Count = Yes as the stated inputs, the result is Total Days = 31 days, Complete Weeks = 4 weeks and Remaining Days = 3 days. Each value corresponds to the declared output fields.

Example 3: Apple Inc. IPO to first trillion-dollar day: Dec 12, 1980 – Aug 2, 2018

Inputs

start_date: 1980-12-12 end_date: 2018-08-02 include_end: No
Total Days: 13,747 days. Complete Weeks: 1,963 weeks. Remaining Days: 6 days. Approx. Months: 451.6 months

With Start Date = 1980-12-12, End Date = 2018-08-02 and Include End Date in Count = No as the stated inputs, the result is Total Days = 13,747 days, Complete Weeks = 1,963 weeks and Remaining Days = 6 days. Each value corresponds to the declared output fields.

Example 4: Medicare open enrollment: Oct 15 to Dec 7, 2024 (include end)

Inputs

start_date: 2024-10-15 end_date: 2024-12-07 include_end: Yes
Total Days: 54 days. Complete Weeks: 7 weeks. Remaining Days: 5 days. Approx. Months: 1.8 months

With Start Date = 2024-10-15, End Date = 2024-12-07 and Include End Date in Count = Yes as the stated inputs, the result is Total Days = 54 days, Complete Weeks = 7 weeks and Remaining Days = 5 days. Each value corresponds to the declared output fields.

Common Use Cases

  • Count days remaining until a vacation or event
  • Calculate days elapsed since a historical date
  • Verify days between billing or subscription dates