DAYS Function in Google Sheets

Calculates the number of days between two dates.

DAYS Function

The DAYS function calculates the number of days between two dates.

Syntax

DAYS(end_date, start_date)
  • end_date: The end date of the period.
  • start_date: The start date of the period.

Examples

  1. Basic Example

Calculate the number of days between August 14, 2024, and January 1, 2024:

=DAYS(DATE(2024, 8, 14), DATE(2024, 1, 1))
  1. Reversed Dates

If the end date is earlier than the start date, DAYS will return a negative number:

=DAYS(DATE(2024, 1, 1), DATE(2024, 8, 14))

Notes

  • This function is useful for determining the exact number of days between two dates.
  • DATEDIF: Calculates the difference between two dates in various units.