DAYS ^v2.6.131 ​

Calculates the number of days between two dates.

DAYS(end_date, start_date)

DAYS(end_date, start_date)

Parameters ​

• end_date - The end date or time value, represented as an Excel date value.
• start_date - The start date or time value, represented as an Excel date value.

Examples ​

DAYS("2022-04-17", "2022-03-20")

DAYS("2022-04-17", "2022-03-20")

Result: 28

Note: Calculates the number of days between the start date (2022-03-20) and the end date (2022-04-17).

DAYS(45033, 44423)

DAYS(45033, 44423)

Result: 610

Note: Calculates the number of days between the start date (44423) and the end date (45033).