Days Between Two Dates Calculator
Counting days between two dates comes up constantly — deadlines, contracts, loan durations, travel planning, age calculations. This guide shows you how to do it manually, in Excel, and with a free calculator.
How to Calculate Days Between Dates Manually
Same year
Example: March 15 to September 20 → Day 263 − Day 74 = 189 days
Across different years
Count days remaining in start year + full years in between (365 or 366 for leap) + days elapsed in final year.
Common Examples
| Period | Approximate Days |
|---|---|
| 1 week | 7 days |
| 1 month (average) | 30.44 days |
| 1 quarter | 91 days |
| 6 months | 182–184 days |
| 1 year (regular) | 365 days |
| 1 year (leap) | 366 days |
How to Calculate in Excel
Basic subtraction:
Format the result cell as Number (not Date) to see the day count.
DAYS function (Excel 2013+):
Working days only (excludes weekends):
Years, months, days with DATEDIF:
Calendar Days vs Working Days
| Use case | Which to use |
|---|---|
| Loan interest calculation | Calendar days |
| Project deadline | Working days |
| Age calculation | Calendar days |
| Delivery estimate | Working days |
| Contract duration | Calendar days (usually) |
📅 Count Days Between Any Two Dates
Get the result in days, weeks, months, and years. Works for past and future dates.
Open Date Difference Calculator →Real-World Use Cases
Contract and notice periods
Many employment contracts specify a notice period in calendar days — typically 30, 60, or 90 days. If you hand in your notice on July 14, a 30-day notice period ends on August 13 (not "end of August"). Getting this wrong can mean leaving money on the table or creating a legal dispute. Calendar-day counting is the correct method here; the calculator removes any ambiguity.
Visa and passport validity
Travel visas are almost always expressed in calendar days from the date of entry, not in months. A 90-day Schengen tourist visa starting on March 1 expires on May 29 — not on June 1. Overstaying even by one day can trigger a ban. Use the calculator to pin the exact expiry date before you travel.
Loan interest and finance
Banks and lenders almost always use actual calendar days for interest calculations on personal loans, mortgages, and overdrafts. A loan issued on January 15 and repaid on April 10 covers 85 calendar days. Knowing the exact day count lets you verify interest charges on your statement.
Project management deadlines
Project timelines usually run on working days, not calendar days. If a client gives you a 20-working-day delivery window starting Monday July 7, the deadline is not July 27 — it is August 4, because weekends push it forward. Always use the working-days toggle when planning project milestones.
School term and exam countdowns
Students and parents use date-difference counting to track how many days remain until end-of-term exams, application deadlines, or results days. A count from today to your exam date helps structure a study plan — for example, "I have 47 days, so I can cover 2 topics per week."
How Months and Years Factor In
Months are not a fixed number of days — they range from 28 to 31. This creates confusion when people estimate how long a period is. Common mistakes:
- "3 months" is assumed to be 90 days, but Jan + Feb + Mar = 90 days only if February has 28 days.
- "Half a year" is sometimes assumed to be 182 days, but it depends on which half — the first half of a leap year (Jan–Jun) is 182 days, while the second (Jul–Dec) is 184 days.
- "A year" is 365 days in regular years and 366 in leap years (2024, 2028, 2032).
The only reliable way to get an exact count is to subtract one date from the other using actual calendar math — which is exactly what the calculator does.
Converting Days to Weeks and Months
| Days | Weeks (approx) | Months (approx) |
|---|---|---|
| 7 days | 1 week | 0.23 months |
| 30 days | 4.3 weeks | ~1 month |
| 60 days | 8.6 weeks | ~2 months |
| 90 days | 12.9 weeks | ~3 months |
| 180 days | 25.7 weeks | ~6 months |
| 365 days | 52.1 weeks | 12 months |
Frequently Asked Questions
Does the calculator include the start and end date?
For most purposes — duration between events — only one end is counted. Our calculator shows both options so you can choose the right convention for your use case.
How many days is 3 months?
Approximately 90–92 days depending on which three months you are counting. January + February + March = 90 days in a regular year (91 in a leap year). April + May + June = 91 days. Use the calculator to get the exact count between specific dates.
What is the difference between DATEDIF and DAYS in Excel?
DAYS simply returns the number of days between two dates. DATEDIF is more flexible — it can return complete months ("M"), complete years ("Y"), or days remaining after full months ("MD"), making it better for age calculations and contract durations.
Do leap years affect the count?
Yes, if your date range spans February 29 of a leap year, that extra day is included in the count. Our calculator handles this automatically. Recent and upcoming leap years: 2020, 2024, 2028, 2032.
What is the fastest way to count days between dates on a phone?
Open the Date Difference Calculator on timekitforall.com in any mobile browser. Enter the two dates and the result appears instantly — no app needed, no sign-up, works offline once the page has loaded.
How do I calculate working days excluding public holidays?
Our working-days toggle excludes weekends (Saturday and Sunday) but does not subtract public holidays, as these vary by country and region. For holiday-adjusted counts, subtract the number of public holidays within your date range from the working-days result.