How Many Days Between Dates? 3 Easy Ways

Anyone who’s ever planned a trip, tracked a project deadline, or simply wondered how long until a holiday has faced the same question: exactly how many days between two dates? Whether you’re counting down to an event or figuring out how many days you’ve been working on a project, knowing the precise day difference is one of those small but surprisingly critical skills.

Days in a common year: 365 ·
Days in a leap year: 366 ·
Leap years per 400-year cycle: 97 ·
Average days per year (Gregorian): 365.2425 ·
Top Google result for “days between two dates”: timeanddate.com (2.7B monthly visits)

This table clarifies the core mechanics behind day-counting across all methods.

The implication: understanding these defaults prevents off-by-one errors in any method you choose.

How Do I Calculate the Number of Days Between Two Dates?

Manual step-by-step counting

• Count the remaining days in the start month, then add the full calendar months between, then add the days of the end month (MathIsFun, an educational math site).
• Leap year adjustments are needed if February falls in the range (every 4 years, century years divisible by 400).
• This method is educational and works without any electronic tool.

Using a calendar

• Physically mark the start date, count through each day until the end date — the simplest but most error-prone.
• For long ranges, use the manual counting formula: days remaining in start month + days in full months + days in end month.

Subtraction method

• Once dates are converted to a serial number (e.g., in spreadsheets or programming languages), subtracting the earlier from the later returns the day difference (Exceljet, a specialist spreadsheet resource).
• This is the core logic behind every digital calculator.

What Is the Formula for Days Between Dates in Excel?

DATEDIF function

• DATEDIF(start_date, end_date, “d”) returns the number of full days between two dates (Microsoft Support, the official Microsoft documentation).
• The “d” unit specifically counts complete 24‑hour periods.

Simple subtraction (end-start)

• In Excel, dates are stored as serial numbers, so =B2-A2 works directly (eCampusOntario, an open textbook publisher).
• Both simple subtraction and DAYS return identical results (Exceljet).

NETWORKDAYS for business days

• NETWORKDAYS(start, end, [holidays]) excludes weekends and optional holiday dates (DataCamp, a data science education site).
• Useful for project timelines and payroll calculations.

Can I Calculate Days Between Dates Online for Free?

Top free calculators

• Timeanddate.com Days Calculator is a free, trusted tool that also shows months, weeks, and hours.
• Calculator.net offers a clean interface with optional inclusion of start/end dates.
• OmniCalculator provides a mobile-friendly design with time zone awareness.

Features to look for

• Leap year handling: automatic without user input.
• End‑date inclusion toggle: some count from start to end (exclusive), some include both endpoints.
• No sign‑up required for basic calculations.

Mobile vs desktop

• Mobile versions of timeanddate.com and calculator.net work well on small screens.
• Desktop versions often allow keyboard date entry and copy‑paste of results.

How to Count Days Between Dates Manually Without a Calculator?

Step-by-step manual counting

1. Count days remaining in the start month (total days in month – start day).
2. Add the total days of each full month in between.
3. Add the days of the end month up to and including the end date.

• Use a month‑length table (Jan=31, Feb=28/29, Mar=31…) and check for leap years.

Counting remaining days in start month

• If start date is March 15, remaining days in March = 31 – 15 = 16.
• If start date is the last day, remaining days = 0.

Adding full months and final month days

• Example: March 15 to June 20 → remaining March: 16 days + April: 30 + May: 31 + June up to 20: 20 = 97 days.
• This method is taught in educational contexts for understanding calendar structure (MathIsFun).

How Many Days Between Dates Including the Start and End Date?

Inclusive vs exclusive counting

• Exclusive counting (default in most tools): the difference between the two dates, not counting the start date. So from Monday to Wednesday is 2 days.
• Inclusive counting adds one day: includes both start and end dates. Monday to Wednesday inclusive = 3 days (Ablebits, an Excel add‑in developer).

Common use cases

• Exclusive: calculating age, loan terms, project duration.
• Inclusive: counting how many days an event lasts (e.g., a weekend workshop Saturday to Sunday inclusive = 2 days).

How calculators handle it

• Timeanddate.com’s Days Calculator defaults to exclusive but offers an “include end date” checkbox.
• Excel’s DATEDIF always returns exclusive (full days between).

“Our Days Calculator counts the number of days between two dates. It also shows the months, weeks, and hours.”

— Timeanddate.com documentation

“To find the number of days between two dates, we can count the days step-by-step: first count the remaining days in the start month, then whole months, then days in the final month.”

— MathIsFun.com

For anyone who needs to plan, track, or measure time across dates, the choice between manual counting, Excel formulas, and online tools comes down to the same question: how much accuracy do you need for the cost of effort? Manual methods teach you the logic but risk slips; spreadsheets handle recurring calculations; online calculators are the fastest for one‑off answers. For most people dealing with everyday deadlines, an online calculator is the clear winner — a free, tested tool that eliminates arithmetic and leap‑year guesswork. Use it, double‑check the counting rule, and move on.

Related reading: Calculate days between dates in Excel – step by step · How to calculate the difference between two dates in Excel

For a quick and accurate count, you can use a free online day calculator that handles leap years and date math automatically.

Frequently asked questions