Date Difference Calculator — Days Between Two Dates
Calculate the number of days, weeks, months, and years between two dates. Find the exact duration between any two dates.
📅 Date & Time
✅ Free
By SwiftCalcTools Editorial Team · Formula verified
Loading Date Difference Calculator…
Preparing your calculator
How to Use Date Difference Calculator
- 1Enter the required values in the input fields above.
- 2Click the Calculate button or results update instantly as you type.
- 3View your results in the output panel below the inputs.
- 4Adjust any values to recalculate instantly.
Frequently Asked Questions
Business days (Monday–Friday) exclude weekends (Saturday and Sunday). This calculator counts every weekday between the two dates. Note: business days differ from "working days" which also exclude public holidays.
This calculator excludes national holidays gazetted by the Government of India including Republic Day (Jan 26), Holi, Good Friday, Eid, Buddha Purnima, Independence Day (Aug 15), Gandhi Jayanti (Oct 2), Dussehra, Diwali, and Christmas (Dec 25) for 2024–2026. Regional holidays vary by state.
Use =DATEDIF(start_date, end_date, "D") for days, "M" for months, "Y" for years. For working days excluding weekends: =NETWORKDAYS(start_date, end_date). For excluding holidays: =NETWORKDAYS(start_date, end_date, holidays_range). Excel's DATEDIF is undocumented but works in all versions.
Calendar days = every day including weekends and holidays (simple subtraction). Business days = Mon–Fri only (excludes weekends). Working days = Mon–Fri minus public holidays. A 30-calendar-day month typically has ~22 business days and ~20–21 working days depending on holidays.