=B1 - A1.
Calculating the exact number of days between two dates is a routine task in legal compliance, financial planning, project management, and everyday scheduling. However, human intuition often miscalculates due to varying month lengths, leap year adjustments, and confusion over boundary day inclusions.
Step 1: Determine the Counting Convention (Inclusive vs. Exclusive)
Before applying any formula, establish whether the timeline requires inclusive or exclusive counting:
- Exclusive Counting: Subtracts the start date from the end date. The start day is treated as Day 0. If an item is rented from Tuesday to Wednesday, that is 1 day.
- Inclusive Counting: Both the start date and the end date are counted as active days. If a training seminar runs Tuesday through Wednesday, participants attend for 2 days.
Step 2: Manual Calendar Counting Method
When computing dates by hand across multiple months, follow this structured three-step formula:
- Step A (Start Month Remaining Days): Subtract the start day from the total days in the start month. (e.g., For April 12, April has 30 days:
30 − 12 = 18 days). - Step B (Intervening Full Months): Sum the standard calendar days for every intervening full month.
- January, March, May, July, August, October, December: 31 days
- April, June, September, November: 30 days
- February: 28 days (or 29 days in a leap year)
- Step C (End Month Days): Add the day number of the end month. (e.g., For June 25, add
25 days).
Example: From April 12, 2026 to June 25, 2026:
Remaining in April: 18 days + Full May: 31 days + June: 25 days = 74 days (exclusive).
Step 3: Calculating Days in Excel and Google Sheets
Modern spreadsheet applications store dates as sequential serial integers (where Day 1 is January 1, 1900 in Excel). Consequently, date subtraction is built directly into basic arithmetic operators:
| Objective | Formula Syntax | Example Result |
|---|---|---|
| Standard Exclusive Difference | =B1 - A1 |
Calculates exact calendar days between cells |
| Inclusive Day Count | =(B1 - A1) + 1 |
Adds boundary day to difference |
| Business Days Only | =NETWORKDAYS(A1, B1, [holidays]) |
Excludes weekends and optional holiday range |
| Full Elapsed Weeks | =INT((B1 - A1) / 7) |
Returns whole weeks without remainder |
Leap Year Rules for Accurate Calculations
A year is a leap year if it is divisible by 4, except when it is divisible by 100, unless it is also divisible by 400. For example:
- 2024 and 2028 are leap years (divisible by 4).
- 1900 was not a leap year (divisible by 100, not 400).
- 2000 was a leap year (divisible by 400).
If your calculation spans February 29, always verify that your tools utilize leap-year-compliant date libraries.
Avoid manual calculation errors entirely by testing your dates in our free, verified Days Between Dates Calculator.