How to Calculate the Number of Days Between Two Dates

PHBy the PDF Hub TeamUpdated

"How many days until…?" and "how many days since…?" come up all the time: notice periods, loan and rent calculations, visa stays, project deadlines, pregnancy weeks, warranty periods. Counting on a calendar is slow and error-prone because months have 28, 29, 30 or 31 days. Here are the reliable methods and the one rule that causes most mistakes.

The quick way

Open the Date Calculator, choose the difference mode, pick the start and end dates and read the result in days, plus weeks, months and years. Switch to add/subtract mode to find the date that is a given number of days away. It uses real calendar dates, so month lengths and leap years are handled automatically.

Worked examples

• 1 January 2026 → 1 March 2026 = 59 days (31 days of January + 28 days of February 2026). • 15 June 2026 → 25 December 2026 = 193 days. • 10 March 2026 + 90 days = 8 June 2026 — a typical "payment due in 90 days" calculation. • 15 August 2026 − 30 days = 16 July 2026.

Inclusive or exclusive?

The standard difference counts the days from the start date up to the end date — the start day is not counted, the end day is reached. From Monday to Wednesday is 2 days. Some situations count both days: a hotel stay from the 1st to the 3rd is 2 nights but 3 calendar days, and a leave application from the 1st to the 3rd usually means 3 days of leave. When both days count, add 1 to the result. Always check which rule your contract, employer or authority uses.

Counting by hand

1. Count the days remaining in the start month (days in month − start day). 2. Add the full days of every month in between. 3. Add the day number of the end date. For 20 January to 5 March 2026: 11 (rest of January) + 28 (February) + 5 = 44 days. Remember: February has 29 days in leap years (2028 is the next one).

In Excel or Google Sheets

Dates are stored as numbers, so the difference is a subtraction: =B1-A1 with the start date in A1 and the end date in B1 (format the result as a number). To add days: =A1+90. For working days only, use =NETWORKDAYS(A1,B1), which excludes weekends and, optionally, a list of holidays.

Calendar days vs. working days

The Date Calculator counts calendar days — weekends and public holidays included. Many legal and contractual periods are defined in calendar days, but some (bank processing, court deadlines in certain jurisdictions) use working days. If you need holidays for a specific country, look them up in the World Calendar and subtract them.

Related calculations

For a person's age in years, months and days, use the Age Calculator — it borrows months correctly, which a simple day count does not. To compare times across countries for a deadline at a specific hour, use the Time Zone Converter.

Everyday uses

Notice periods: a 60-day notice given on 15 June 2026 ends on 14 August 2026 (15 June + 60 days), depending on whether your contract counts the first day. Rent and interest: daily interest or pro-rated rent = monthly amount × days ÷ days in the month. Visa stays: many rules limit days within a period, and both entry and exit days often count — check the official rule. Pregnancy and medical schedules: count weeks from a reference date; the calculator shows the result in weeks as well as days. Warranties and returns: add the warranty period in days to the purchase date to know the last day to claim.

Use real calendar dates, decide whether both ends count, and distinguish calendar days from working days. The Date Calculator handles month lengths and leap years for you; add 1 when a period includes both the first and last day. For anything with legal or financial consequences — a notice period, a filing deadline, a visa limit — write down the rule you used and the dates you entered, so the calculation can be checked later by someone else.

Frequently asked questions

Does the day count include the start date?

The standard difference does not count the start day but reaches the end day. If both the first and last day should count, add 1.

How many days are left until a date?

Use today as the start date and the target as the end date in the Date Calculator. The result is the number of days remaining.

How many weeks are 100 days?

14 weeks and 2 days (100 ÷ 7 = 14 remainder 2).

Can I exclude weekends?

The Date Calculator counts calendar days. For working days, use NETWORKDAYS in Excel or Google Sheets and subtract public holidays.

What date is 45 days from 1 July 2026?

15 August 2026 (30 remaining days of July after 1 July, plus 15 days of August).

Try the tool

Date Calculator

Open tool

Related guides