Count day boundaries between times

Turn 7/4/2026 11:59:59 PM to 7/5/2026 12:01:59 AM into 1 day boundary.

What you'll make

In Excel: 7/4/2026 11:59:59 PM to 7/5/2026 12:01:59 AM becomes 1.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1INT(B8)Gets the end date, dropping its time.11/5/2026
2-INT(A8)Takes away the start date, also without its time.1

Read it left to right. Only the dates count: two minutes across midnight gives 1.

=INT(B8)-INT(A8)

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates and times. Paste start and end dates with times into the green columns of the Template tab. The counts fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

This counts midnights passed, not full days. Use the same time zone for both cells, and put the earlier one in Start.

Microsoft's help: INT function