An equipment loan starts May 4, 2026 and ends May 7. The elapsed period is three days. If the booking sheet charges for every calendar date touched, the same range contains four dates.
Write the rule beside the formula
Use real dates in A2 and B2. For elapsed calendar days use =B2-A2. For dates including both ends use =B2-A2+1. Format the result as a number. Both formulas count across weekends.

Illustrated date counting. Decide whether you are counting gaps or occupied dates.
Test the boundaries with one row
Set the end date equal to the start. Expect 0 elapsed and 1 inclusive. If the end is earlier, mark the row for review before applying the inclusive calculation. Keep one column heading for each counting rule so the two results are easy to tell apart.

Illustrated same-date check. A reversed range needs review.



