On-device AI — professional-grade, fully private.

Documents

How to Count the Days Between Two Dates (Including Working Days)

Counting days sounds trivial until you have to decide whether to include the last day, skip weekends, or allow for public holidays. Here is how to get the number right for deadlines, contracts and planning.

Updated October 22, 20265 min read

"How many days until the deadline?" has more than one correct answer. Calendar days or working days? Counting today or not? Including the deadline day itself? Do public holidays count? For a holiday countdown the difference is trivia. For a notice period, a payment term, a visa stay or a project plan, a one-day error can cost money. Getting the number right starts with deciding which number you actually need.

The three questions to answer first

  1. 1Calendar days or working days? Payment terms ("net 30") are usually calendar days; delivery estimates and many legal deadlines are working days.
  2. 2Inclusive or exclusive? From Monday to Friday is 4 days if you count the gaps, or 5 if you count every day including both ends. Hotel nights are exclusive; a five-day course is inclusive.
  3. 3Which holidays? Working-day counts depend on the country — and sometimes the region — whose public holidays apply.

Write those three answers down before you calculate. Most disagreements about a date are not arithmetic errors; they are two people silently answering one of these questions differently.

Counting days, step by step

1

Enter the start and end dates

Open the date calculator and enter both dates. The result is shown in days, weeks and months at once.

2

Decide whether to include the end date

Toggle inclusive counting if both the first and the last day should count — the usual reading for course lengths, rental periods and "days of leave".

3

Switch to working days if needed

Working days skip the weekend automatically — Saturday and Sunday by default, or choose another working week such as Sunday to Thursday or a six-day week. Choose the country whose public holidays apply, or add your own list — company shutdown days, for example.

4

Or add days to a date

For "30 working days from today", add days instead of measuring between two dates. The calculator skips weekends and holidays as it counts forward or back.

Days, weeks, months and working days between any two dates; add or subtract working days skipping weekends and public holidays for fourteen countries, or your own holiday list. Free, in your browser.

Count days between two dates

Why months are the awkward unit

Days and weeks are fixed lengths; months are not. From 31 January, "one month later" could reasonably be 28 February, 29 February in a leap year, or 3 March if you count 31 days. Calendars and contracts usually take the first reading — the same day number next month, or the last day of a shorter month — and that is how the calculator adds months.

So when a term says "three months", it is safer to compute the actual end date than to multiply by 30. Three months from 30 November is 28 or 29 February, not 28 February plus two days.

Common calculations

QuestionTypeWatch out for
Days until a holiday or eventCalendar, exclusiveWhether today counts
Length of a notice periodCalendar or working, per contractHolidays inside the period
Invoice due (net 30)CalendarDue date falling on a weekend
Delivery in 5 business daysWorking daysThe carrier's own holidays
Days of annual leave usedWorking days, inclusiveHalf days and public holidays in the range
Visa or tax-residence daysCalendar, inclusiveArrival and departure days usually both count

Days between dates in Excel

In a spreadsheet, subtracting one date from another gives calendar days: =B1-A1. Add 1 if both ends should count. For working days, =NETWORKDAYS(A1,B1) counts Monday to Friday inclusive of both dates, and =NETWORKDAYS(A1,B1,H1:H20) also skips the holidays listed in H1:H20. To add working days, use =WORKDAY(A1,30,H1:H20).

These functions only know the holidays you give them. Keeping that list current every year is the part people forget, which is where a calculator with maintained holiday calendars saves the most mistakes.

Time zones and the edge of the day

Dates change at midnight local time, and midnight is not the same moment everywhere. A deadline of "23:59 on 31 October" in Sydney passes about 13 hours before the same wall-clock time in London. For deadlines shared across countries, state the time zone explicitly — see converting time zones — and for date stamps stored in data, see Unix timestamps.

Checking your result

  • Sanity-check with weeks. 70 calendar days is exactly 10 weeks; 50 working days is about 10 weeks without holidays.
  • Look at the end date's weekday. A deadline landing on a Saturday usually moves — check whether your contract moves it forward or back.
  • Write the rule next to the number. "42 calendar days, inclusive" is unambiguous; "42 days" is a future argument.

Worked examples

A 30-day payment term. An invoice dated 3 March with "net 30" is due on 2 April: 30 calendar days later, counting from the day after the invoice. If 2 April falls on a weekend, check the contract — many terms move the due date to the next working day, some to the previous one.

A notice period of four weeks. Notice given on Monday 6 October ends on Monday 3 November — exactly 28 calendar days later. Weeks are fixed lengths, so they are the least ambiguous way to express a period; months are the most ambiguous.

Ten working days for delivery. An order placed on Thursday 18 December with a ten-working-day promise does not arrive on 1 January: weekends and the holidays in between push it into the second week of January in most countries. This is exactly the calculation people get wrong by counting on their fingers.

Days until a date

Countdowns to birthdays, exams, launches or trips are the lightest use of a date calculator — but the inclusive/exclusive question still applies. "Days until Friday" asked on Monday is 4 by most people's reckoning (Tuesday, Wednesday, Thursday, Friday), which is the exclusive count from today. Set the start date to today and read the calendar-day result.

Frequently asked questions

How do I calculate the number of days between two dates?

Enter both dates in the date calculator. It shows the difference in days, weeks and months, and you can choose whether the end date is included and whether to count only working days.

How do I count working days and skip holidays?

Switch to working days and choose the country whose public holidays apply, or add your own list. Weekends are skipped automatically, and holidays inside the period are excluded.

Should I include the start and end date?

It depends on what you are measuring. Hotel nights and countdowns exclude one end; courses, leave and residence days usually include both. Decide before you count and write the rule down with the number.

How do I count days between dates in Excel?

Use =B1-A1 for calendar days (add 1 to include both ends), =NETWORKDAYS(A1,B1,holidays) for working days, and =WORKDAY(A1,N,holidays) to add N working days.

Keep reading

More in Documents →