DAYS

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

Syntax

=DAYS(end_date, start_date)

Parameters

• end_date: The ending date
• start_date: The starting date

Examples

=DAYS("2024-01-01", "2023-12-25") // Returns 7
=DAYS(DATE(2024, 2, 1), DATE(2024, 1, 1)) // Returns 31