DATEDIFF
Calculates the difference between two specified dates in the given interval. If date2 is before date1, then the result will be negative.
Syntax
=DATEDIFF(interval, date1, date2)
Arguments
Argument | Type | Description |
---|---|---|
interval | String | The type of interval to find the difference of Valid intervals are: - YEARS - YEAR - QUARTERS - QUARTER - MONTHS - MONTH - WEEKS - WEEK - DAYS - DAY - HOURS - HOUR - MINUTES - MINUTE - SECONDS - SECOND - MILLISECONDS - MILLISECOND |
date1 | Date | The starting date |
date2 | Date | The ending date |
Examples
=DATEDIFF("YEARS", DATE(2019), DATE(2020))
→1
Gets the number of years from Jan 1, 2019 12:00 AM to Jan 1, 2020 12:00 AM
=DATEDIFF("YEARS", DATE(2021), DATE(2019))
→-2
Gets the number of years from Jan 1, 2021 12:00 AM to Jan 1, 2019 12:00 AM
=DATEDIFF("MINUTES", DATE(2020, 1, 2, 3), DATE(2020, 2, 3, 4))
→46140
Gets the number of minutes from Jan 2, 2020 3:00 AM to Feb 3, 2020 4:00 AM
Updated 8 months ago