Days Between Two Dates Calculator: How to Calculate Days, Weeks & Working Days
Short answer: To find the days between two dates, subtract the earlier date from the later date. For example, 1 January 2026 to 1 February 2026 is 31 days. AgeCalc PK's free Date Duration Calculator does this instantly and also shows the result in weeks, months and working days.
Whether you are counting down to a deadline, planning a trip, checking a notice period, or simply curious how long ago something happened, date math comes up all the time. The formula itself is simple, but most mistakes happen for one reason: people are not sure whether the start date, the end date, or both should be counted. This guide clears that up, with worked examples you can check by hand.
How to Calculate Days Between Two Dates (The Formula)
The standard method is:
Days between = End date − Start date
Each date is converted into a day number on the calendar, and the earlier one is subtracted from the later one. The result counts the days that pass after the start date, up to and including the end date. That is called exclusive counting of the start date, and it is the convention most calculators and spreadsheets use.
A simple way to remember it: think of hotel nights. If you check in on Monday and check out on Friday, you stay 4 nights, not 5 — even though 5 calendar dates are involved. The same logic applies to days between dates.
Worked Examples You Can Verify
| Start date | End date | Days between | In weeks |
|---|---|---|---|
| 1 January 2026 | 1 February 2026 | 31 days | 4 weeks, 3 days |
| 1 March 2026 | 31 March 2026 | 30 days | 4 weeks, 2 days |
| 1 January 2026 | 31 December 2026 | 364 days | 52 weeks exactly |
| 1 January 2026 | 1 January 2027 | 365 days | 52 weeks, 1 day |
| 29 October 2026 | 25 December 2026 | 57 days | 8 weeks, 1 day |
Notice the last two rows: 1 January to 31 December of the same non-leap year is 364 days, not 365, because the start date itself is not counted. Add one day and you reach 1 January of the next year — a full 365 days. If your answer is off by exactly one, the counting convention is almost always the cause.
Inclusive vs Exclusive Counting: Which One Do You Need?
This single choice changes the answer by one, so decide it before you calculate:
- Exclusive (standard): End date − Start date. Use this for "how many days until", elapsed time, and durations. Example: 1 January to 5 January = 4 days.
- Inclusive (both dates counted): End date − Start date + 1. Use this when both the first and last day belong to the period, such as a 3-day event running Thursday to Saturday, or a leave period written as "from the 11th to the 15th inclusive". Example: 1 January to 5 January = 5 days.
For contracts, notice periods and payment deadlines, always check the wording first. Phrases like "within 30 days" and "30 days from" can be interpreted differently, and a one-day error on a legal deadline is expensive. When in doubt, confirm which convention the other party is using.
Converting the Result: Weeks, Months and Years
A raw day count is useful, but most people want the answer in friendlier units:
- Weeks: Divide by 7. For example, 57 days = 8 weeks and 1 day.
- Months: Calendar months vary (28 to 31 days), so there is no single exact conversion. A calculator that steps month by month along the real calendar gives the honest answer — for example, 1 January to 1 April is exactly 3 calendar months, or 90 days in 2026.
- Years: A normal year has 365 days and a leap year has 366. A span crossing 29 February gains an extra day, which is why 2028, a leap year, matters for any range that includes February 2028.
AgeCalc PK's Date Duration Calculator handles all of this automatically, including leap years, so you never have to count February by hand.
Working Days Between Two Dates
For office work, the more useful number is often working days — Monday to Friday, excluding weekends. The rule is simple: count only weekdays in the range. Public holidays are a separate question, because they vary by country and by year, so a general calculator counts weekdays only and you subtract your local holidays yourself.
This matters for project deadlines, invoice payment terms such as "net 30", HR notice periods and leave calculations. If you need working days in Pakistan, start with the weekday count and then remove the public holidays that fall inside your range — our Islamic calendar 2027 for Pakistan can help you spot the Islamic holidays in advance.
Calculating Days in Excel and Google Sheets
If you work in spreadsheets, you do not need a separate tool:
- Days between:
=B1-A1where A1 is the start date and B1 is the end date, formatted as a number. - Working days:
=NETWORKDAYS(A1,B1)— note this counts both endpoints, so it is one more than the exclusive day count for weekday-only ranges. - Add days:
=A1+30gives the date 30 days after the date in A1.
Common Uses: Deadlines, Travel, Birthdays and Countdowns
Date-difference math powers many of the tools on AgeCalc PK. Counting to a birthday is the same calculation as counting to a holiday — only the end date changes. Try it with our birthday countdown guide or the Ramadan 2027 countdown for Pakistan: pick today as the start date and your event as the end date, and the day count is your countdown. The same method works for exam dates, visa expiry dates, wedding anniversaries and project launches.
It also works backwards: put the past date first and today second to see how long ago something happened. For age in years, months and days, use our free age calculator for Pakistan instead.
Frequently Asked Questions
How many days are between 1 January and 31 December of the same year?
364 days in a non-leap year (365 in a leap year), using the standard exclusive count. Counting both endpoints gives 365 (366 in a leap year).
Do you count the start date when calculating days between dates?
No, not in the standard method. The start date is day zero and the days after it are counted. If your situation requires counting both dates, add 1 to the result.
How do leap years affect the calculation?
A range that includes 29 February has one extra day compared with the same range in a non-leap year. Good calculators add this automatically; when counting by hand, check whether February in your range has 29 days.
How do I calculate working days between two dates?
Count only Monday to Friday inside the range, then subtract any public holidays that apply to you. In Excel or Google Sheets, NETWORKDAYS does the weekday part for you.
What is the easiest way to calculate days between two dates?
Use AgeCalc PK's free Date Duration Calculator: enter the start and end dates and get the total days, weeks, months and working days instantly, with leap years handled for you.
Bottom line: Days between two dates = end date minus start date, with the start date not counted. Decide inclusive vs exclusive first, watch out for leap years, and let the calculator do the rest.