Date Difference Calculator in Days, Weeks and Months
A date difference calculator in days, with the same span in weeks, months and years, an option to include the end date, and business days.
Days between the dates
- Calendar days
- 364 days
- Business days
- 260 days
- Weekend days
- 104 days
- Weeks and days
- 52 weeks, 0 days
- Months and days
- 11 months, 30 days
- Years, months, days
- 0 years, 11 months, 30 days
How to use the Date Difference Calculator
- Pick a start date and an end date. The order does not matter.
- Turn on “Include the end date” if both the first and the last day should count, as for a hotel booking's nights versus days or a leave request.
- Turn on “Business days only” to leave out weekends, and choose which days are your weekend.
- Read the total in days, then the same span in weeks, months and years below it.
Formula
Days = end date − start date (+ 1 if the end date is included)
Where:
- end − start
- Calendar days from the start date to the end date; the start date counts, the end date does not
- + 1
- Added when the end date is included, so Monday to Friday is 5 days instead of 4
- Weeks
- Whole weeks = days ÷ 7, rounded down; the remainder is the extra days
- Months, years
- Whole calendar months counted from the start date, then the days left over
- Business days
- Days in the span that are not weekend days. Public holidays are not removed
Dates are calendar dates in your own time zone, so daylight saving time never adds or removes a day.
Worked example
How many days are there from January 1, 2026 to December 31, 2026, counting both dates?
- Without the end date: December 31 is day 365 of 2026 and January 1 is day 1, so the difference is 364 days.
- Including the end date adds 1: 364 + 1 = 365 days.
- In weeks: 365 ÷ 7 = 52 weeks with 1 day left over.
- Weekend days (Saturdays and Sundays) in 2026: 104. Business days: 365 − 104 = 261.
There are 365 days (exactly 1 year) from January 1 to December 31, 2026 with both dates counted, of which 261 are business days.
How to calculate the days between two dates
Subtract the earlier date from the later one. By default the start date counts and the end date does not, so January 1 to January 2 is 1 day, or 2 days if you count both. Everything else on this page builds on that one rule.
If you enter the dates in the wrong order, the tool swaps them, shows the positive span and says it did so. Any date from 1600 to 2999 works, and leap years and months of different lengths are handled for you.
Example: a stay from February 15 to August 20, 2026
- Days from February 15 to August 20, end date not included: 186 days.
- As weeks: 186 ÷ 7 = 26 weeks and 4 days.
- As months: February 15 to August 15 is 6 whole months, plus 5 days: 6 months and 5 days.
- If the departure day also counts, include the end date: 187 days, or 6 months and 6 days.
- Business days (Monday to Friday): 133 without the end date, 134 with it.
Many visa and residence rules count every calendar day in the country, arrival and departure included, so the inclusive figure is usually the one to check. Always confirm how the authority you deal with counts days.
Is the end date included?
Only if you switch it on, and the right choice depends on what you are measuring.
- Elapsed time leaves it out. From Monday to Friday, four days have passed. Hotel nights, interest periods and "how long ago" questions work this way.
- Inclusive periods count both ends. A leave request from Monday to Friday uses five days, and a course from March 2 to June 30 includes both of those days.
The switch adds exactly one day. Getting this wrong is the most common reason two people get different answers for the same dates. Contract phrases such as "within 30 days of" decide which applies.
Weeks, months and years between dates
Weeks are simple, because every week has seven days: whole weeks plus the days left over. Months are not, because they have 28 to 31 days. The tool therefore counts calendar months from the start date: January 15 to February 15 is one month, whatever the number of days, and the remainder is shown as days. A start on the 29th, 30th or 31st ends a month on the last day of a shorter month, so January 31 to February 28, 2026 is one month. Spreadsheets and most date libraries use the same convention.
Leap years matter over long spans: 2024 and 2028 have 366 days, and February 29, 2024 to February 28, 2025 is exactly 365 days and one full year.
Business days: leaving out weekends
Business days are the days in the period that are not weekend days. You can choose the weekend: Saturday and Sunday, Friday and Saturday (used in Saudi Arabia, Bangladesh, Egypt and Israel, among others), Sunday only, or Friday only.
Public holidays are not removed, because they differ by country, region, employer and year. Count the holidays in your period and subtract them. A project from Monday, March 2 to Tuesday, June 30, 2026, both days included, is 121 days, or 87 business days; with three public holidays, the team has 84 working days.
How many working days are in a year? Counting January 1 to December 31 inclusive with a Saturday and Sunday weekend, 2026 and 2027 each have 261 and 2028 has 260, before holidays. Do not estimate business days as five-sevenths of calendar days for short spans: Friday to Monday, inclusive, is 4 calendar days but only 2 business days.
The same calculation in Excel or Google Sheets
With the start date in A2 and the end date in B2:
=B2-A2(or=DAYS(B2, A2)) gives the days with the end date excluded; add 1 to include it.=NETWORKDAYS(A2, B2)counts Monday to Friday with both dates included, which matches this tool's business days with the end date switched on. An optional third argument takes a range of holiday dates.=NETWORKDAYS.INTL(A2, B2, 7)uses a Friday and Saturday weekend.=DATEDIF(A2, B2, "M")gives whole months.
Assumptions
Dates use the Gregorian calendar and are read as calendar dates on your own device, so daylight saving changes never add or remove a day and the result is the same in every time zone. Times of day are not used; for hours and minutes, use the time duration page. The page address stores both dates and every option, so a shared link reproduces your count.
Frequently asked questions
How do I calculate the number of days between two dates?
Subtract the earlier date from the later one, counting the days in each month between them. From January 1 to December 31, 2026 that is 364 days. If both the first and the last day should count, add 1, giving 365. The tool does this instantly and handles leap years and months of different lengths.
Does the count include the start date?
The start date always counts; the end date counts only if you include it. So January 1 to January 2 is 1 day, or 2 days with the end date included. Leave it off for elapsed time, such as hotel nights or how long ago something happened. Include it when both the first and last day are used, as in a leave request from Monday to Friday: 5 days instead of 4.
How many weeks are between two dates?
Count the days, divide by 7 and keep the remainder as extra days. February 15 to August 20, 2026 is 186 days, which is 26 weeks and 4 days. Including the end date makes it 187 days, or 26 weeks and 5 days. The Weeks and days row shows this split automatically for any pair of dates.
How many months are between two dates?
Months have 28 to 31 days, so they are counted as calendar months from the start date: January 15 to February 15 is 1 month, then the days left over are added. February 15 to August 20, 2026 is 6 months and 5 days. A start on the 31st counts a month to the last day of a shorter month, so January 31 to February 28, 2026 is 1 month.
How many working days are in a year?
With a Saturday and Sunday weekend and both January 1 and December 31 counted, 2026 has 261 weekdays, 2027 has 261 and 2028 has 260. Public holidays are not removed, because they differ between countries, states and employers, so subtract your own: 261 weekdays minus 10 public holidays leaves 251 working days.
How do I calculate days between dates in Excel?
Subtract the cells: with the start date in A2 and the end date in B2, =B2-A2 gives the days without the end date, and adding 1 includes it. For weekdays only, =NETWORKDAYS(A2, B2) counts Monday to Friday with both dates included and accepts a holiday list as a third argument. Google Sheets uses the same formulas.
Related calculators
- Add or Subtract Days CalculatorUse this add days to date calculator to add or subtract days, weeks, months or years from any date, counting calendar or business days.
- Age CalculatorUse this age calculator by date of birth to find your exact age in years, months and days, today or on any other date.
- Time Duration CalculatorA time duration calculator: hours and minutes between two times, even across midnight, plus a mode to add or subtract time from a clock time.
- Loan CalculatorUse this loan calculator with amortization schedule to see the monthly payment, total interest and month-by-month breakdown for any fixed-rate loan.
Last updated: