Excel Date Count Including the Start Date: When +1 Is Needed
For an Excel date count including the start date, the usual formula is <code>=B2-A2+1</code> when the end date also counts. But +1 is not a universal fix: a one-sided endpoint rule, weekends, holidays, and elapsed time each need a different definition. This guide uses A2 for the start date and B2 for the end date so you can choose the formula from the counting rule.
On this page
The answer: Excel date count including the start date uses +1 when both dates count
If April 1 through April 10 means that every calendar date is a counted day, use =B2-A2+1. With A2 set to 2026/04/01 and B2 set to 2026/04/10, =B2-A2 returns 9 while the inclusive formula returns 10. The extra one represents the start date that ordinary subtraction treats as the zero point.
For elapsed time, keep =B2-A2. Record the endpoint rule before copying the formula.
A start-only rule, an end-only rule, and an exclusive rule are also possible. Compare the four definitions with the site’s inclusive day-count calculator when you need to agree on a policy before building the sheet.
| What you need | Copy-ready formula | April 1 to April 10 |
|---|---|---|
| Elapsed difference | =B2-A2 |
9 days |
| Both dates included | =B2-A2+1 |
10 days |
| Start date counted in a boundary rule | =B2-A2+1 |
10 days when the end is a boundary |
| Neither endpoint included | =B2-A2-1 |
8 days |
| Weekdays and holidays excluded | =NETWORKDAYS(A2,B2,holiday_range) |
Depends on weekdays and the list |
Three checks before writing the formula
- Do you need elapsed time, or the number of calendar dates on a list?
- Should the start date, end date, both, or neither be counted?
- Should weekends, public holidays, or company closures be removed?
Prepare real date cells first
If A2 or B2 is text, the formula may return #VALUE! even though the cell looks like a date. Verify that Excel recognizes both cells; changing the display format alone does not convert imported text.
CSV imports, leading apostrophes, and regional date strings are common causes. Build a value with =DATE(2026,4,1), test =B2-A2, and keep the input format consistent down the column. See Microsoft’s DATE function documentation.
The ordinary difference is B2-A2; DAYS makes the order explicit
With A2 as the start date and B2 as the end date, =B2-A2 is the shortest formula. April 1 to April 10 returns 9 because subtraction measures the distance between date boundaries.
Use =DAYS(B2,A2) when the function name should explain the operation. DAYS takes the end date first and the start date second; reversing the order returns a negative value.
Use =ABS(B2-A2) only when order genuinely does not matter. In payroll or billing data, keep a negative result visible until the input order is checked.
Separate elapsed days from counted days in the column name
Name the columns clearly: “elapsed days” for B2-A2 and “counted days, inclusive” for B2-A2+1. For an order warning, use =IF(B2<A2,"Check date order",B2-A2) and correct the input instead of hiding a negative value.
Why +1 includes the start and end dates
If you mark April 1 through April 10 on a calendar, you mark 10 dates. Plain subtraction returns 9 because it counts boundaries; adding one converts that distance into the number of listed dates.
A contract or billing policy may count one endpoint or treat the end as the next period’s boundary. Confirm whether April 1 and April 10 are covered dates, then record the rule beside the formula.
When both cells contain the same date, B2-A2 returns 0 but B2-A2+1 returns 1. Keep a note such as “both endpoints included” for one-sided rules so the adjustment remains auditable.
Quick April 1 to April 10 check
- Elapsed difference:
=B2-A2→ 9 days - Both endpoints included:
=B2-A2+1→ 10 days - Same date: ordinary difference is 0; inclusive count is 1
DATEDIF displays years, months, and days; it does not replace +1
For a readable period such as “2 years, 3 months, 12 days,” combine DATEDIF units: "y" for complete years, "ym" for remaining months, and "md" for remaining days. This is not an inclusive total-day formula.
A combined cell can use =DATEDIF(A2,B2,"y")&" years, "&DATEDIF(A2,B2,"ym")&" months, "&DATEDIF(A2,B2,"md")&" days". Keep a separate total-day cell for month-end and leap-year checks.
DATEDIF errors when the start follows the end, and months have different lengths. Decide which representation is official and confirm the units in Microsoft’s DATEDIF documentation.
Keep total days for month-end and leap-year cases
January 31 to February 28 and leap-year periods can look different as calendar units. Store the readable period and total day count, then use actual dates for billing or deadlines.
Use TODAY when the count should update through the current date
If A2 is the start date, =TODAY()-A2 returns elapsed days through today; use =TODAY()-A2+1 when the start is day one. TODAY recalculates for live lists.
A future start date produces a negative number. For a countdown, show “not started.” For a reproducible month-end report, use a saved as-of date and label it as the calculation date.
Leave a future date in a clear state
=IF(A2>TODAY(),"Not started",TODAY()-A2)- For an inclusive start date, change the final expression to
TODAY()-A2+1. - For a frozen report, replace TODAY with a saved reference date.
Use NETWORKDAYS when weekends and holidays do not count
For weekdays, use =NETWORKDAYS(A2,B2). It excludes Saturday and Sunday and counts qualifying endpoints, which is different from adding +1 to calendar days.
To remove holidays or company closures, list date-only values in F2:F20 and use =NETWORKDAYS(A2,B2,$F$2:$F$20). Keep the range fixed and free of notes. Use NETWORKDAYS.INTL for another weekend pattern and WORKDAY when the output should be a date. See Microsoft’s NETWORKDAYS documentation.
Calendar day counts and business-day counts answer different questions
=B2-A2+1 counts calendar dates at both endpoints, while =NETWORKDAYS(A2,B2,holiday_range) counts qualifying workdays. For a weekday, weekend, and holiday breakdown, compare the sheet with the site’s business-day calculator or weekday and holiday calculator.
Troubleshoot a result that is one day off
When the formula looks reasonable but the answer is different, check the cell type, endpoint definition, and holiday range in that order. A result of 9 instead of 10 for April 1 through April 10 may simply be elapsed distance rather than inclusive calendar dates.
| Symptom | Likely cause | Check or fix |
|---|---|---|
| The result is #VALUE! | A date is stored as text | Build a real date with DATE and verify the cell type |
| The result is always one day short | Elapsed and inclusive rules were mixed | Compare B2-A2 with B2-A2+1 and state the rule |
| The result is negative | The end date is before the start date | Correct the order before considering ABS |
| DATEDIF returns an error | The start date follows the end date | Confirm both cells are dates and A2 is on or before B2 |
| The business-day total is too high | The holiday range was omitted | Add a date-only third argument to NETWORKDAYS |
| The answer changes each day | TODAY is part of the formula | Use a saved as-of date when the report must be fixed |
Check the formula with an online calculator
After writing the formula, use the site’s Excel date calculator to compare ordinary, inclusive, business-day, and today-based results with the same dates and holiday rules.
Use the inclusive day-count calculator for four endpoint rules or the date difference calculator for a plain difference. Treat the online value as a check, then keep the formula and policy with the spreadsheet.
Use the date calculatorSummary: define the count before choosing the formula
For an Excel date count that includes both endpoints, use =B2-A2+1. Use =B2-A2 for elapsed days, DATEDIF for a years-months-days display, TODAY for a live count, and NETWORKDAYS for weekdays with optional holidays.
When unsure, calculate ordinary and inclusive values with a concrete example, compare the worksheet with the site’s Excel date calculator, and adopt the written business rule.
Excel date count including the start date FAQ
How do I include the start date in an Excel day count?
Put the start date in A2 and the end date in B2, then use =B2-A2+1. April 1 through April 10 returns 10 days.
What is the difference between B2-A2 and B2-A2+1?
B2-A2 measures elapsed distance between dates. B2-A2+1 counts both calendar endpoints as included days.
Does a start-only rule also need +1?
It can, when the start is a counted date and the end is a boundary. Confirm the policy language instead of inferring it from the words “from” or “through.”
What happens when both cells contain the same date?
The ordinary difference is 0; the inclusive count is 1. This matters for one-day leave or a single-date event.
Can I add +1 to DATEDIF to include the start date?
DATEDIF displays a calendar period in years, months, and days. It is not a replacement for an inclusive total-day formula, so keep B2-A2+1 as a separate calculation.
How do I include the start date while excluding weekends and holidays?
Use NETWORKDAYS(A2,B2,holiday_range). It counts qualifying weekdays at the endpoints; the result is not the same as adding one to a calendar-day difference.
Why is my Excel result one day off?
Check the endpoint rule, text dates, hidden times, reversed inputs, and the holiday range. A result of 9 instead of 10 may be the intended elapsed difference.
Verify function behavior with official documentation
Use Microsoft Support when you need to confirm argument order, date units, or holiday handling.