Functions
DAYS
Number of days between two dates
Try it
When to use it
When should I use DAYS?
Use DAYS to calculate the number of days between two dates — useful for measuring contract durations, project timelines, or the elapsed days between any two calendar dates.
Used in
Syntax
DAYS(end,start)Examples
=DAYS("7/24/1969","7/16/1969") // => 8
=DAYS("2/28/2016","2/28/2017") // => -366
=DAYS(DATE(2024,1,1),DATE(2023,1,1)) // => 365