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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | INT(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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Write a full date with an ordinal day
November 4, 2026 → 4th November 2026
Get the template →
Get a date’s day-of-year number
November 4, 2026 → day 308
Get the template →
Count completed weeks between dates
November 4, 2026 to November 11, 2026 → 1 week
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →