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.

May 4, 5, 6 and 7 are shown as four dates separated by three gaps.

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.

Starting and ending on May 4 gives zero elapsed days and one inclusive day.

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

Microsoft Excel instructions