Skip to content

Days between two dates

Count the calendar days from a start date to an end date.

The formula

Argument separator
Excel and Google Sheets
=DAYS(B2, A2)

How it works

  1. B2

    The end date (comes first in DAYS).

  2. A2

    The start date.

Example

A: StartB: EndC: Result
2026-01-012026-01-3130
2026-02-152026-03-0114

Tips

  • =B2-A2 gives the same number; format the cell as Number, not Date.
  • Add 1 if both the start and end day should count.