DATEDIF

Date/Time Functions:
Function: DATEDIF() - Calculates the number of days, months, or years between two dates.
Between: 1900-01-01 and 2026-04-15
In years ("Y"): 126
In months ("M"): 1515
In days ("D"): 46126
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 104
Between: 1904-01-01 and 2026-04-15
In years ("Y"): 122
In months ("M"): 1467
In days ("D"): 44665
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 105
Between: 1936-03-17 and 2026-04-15
In years ("Y"): 90
In months ("M"): 1080
In days ("D"): 32901
In days ignoring months and years ("MD"): 29
In months ignoring days and years ("YM"): 0
In days ignoring years ("YD"): 29
Between: 1960-12-19 and 2026-04-15
In years ("Y"): 65
In months ("M"): 783
In days ("D"): 23858
In days ignoring months and years ("MD"): 27
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 117
Between: 1999-12-31 and 2026-04-15
In years ("Y"): 26
In months ("M"): 315
In days ("D"): 9602
In days ignoring months and years ("MD"): 15
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 105
Between: 2000-01-01 and 2026-04-15
In years ("Y"): 26
In months ("M"): 315
In days ("D"): 9601
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 105
Between: 2019-02-14 and 2026-04-15
In years ("Y"): 7
In months ("M"): 86
In days ("D"): 2617
In days ignoring months and years ("MD"): 1
In months ignoring days and years ("YM"): 2
In days ignoring years ("YD"): 60
Between: 2020-07-04 and 2026-04-15
In years ("Y"): 5
In months ("M"): 69
In days ("D"): 2111
In days ignoring months and years ("MD"): 11
In months ignoring days and years ("YM"): 9
In days ignoring years ("YD"): 285
Between: 2020-02-29 and 2026-04-15
In years ("Y"): 6
In months ("M"): 73
In days ("D"): 2237
In days ignoring months and years ("MD"): 17
In months ignoring days and years ("YM"): 1
In days ignoring years ("YD"): 46