DATEDIF

Date/Time Functions:
Function: DATEDIF() - Calculates the number of days, months, or years between two dates.
Between: 1900-01-01 and 2026-06-24
In years ("Y"): 126
In months ("M"): 1517
In days ("D"): 46196
In days ignoring months and years ("MD"): 23
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 174
Between: 1904-01-01 and 2026-06-24
In years ("Y"): 122
In months ("M"): 1469
In days ("D"): 44735
In days ignoring months and years ("MD"): 23
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 175
Between: 1936-03-17 and 2026-06-24
In years ("Y"): 90
In months ("M"): 1083
In days ("D"): 32971
In days ignoring months and years ("MD"): 7
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 99
Between: 1960-12-19 and 2026-06-24
In years ("Y"): 65
In months ("M"): 786
In days ("D"): 23928
In days ignoring months and years ("MD"): 5
In months ignoring days and years ("YM"): 6
In days ignoring years ("YD"): 187
Between: 1999-12-31 and 2026-06-24
In years ("Y"): 26
In months ("M"): 317
In days ("D"): 9672
In days ignoring months and years ("MD"): 24
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 175
Between: 2000-01-01 and 2026-06-24
In years ("Y"): 26
In months ("M"): 317
In days ("D"): 9671
In days ignoring months and years ("MD"): 23
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 175
Between: 2019-02-14 and 2026-06-24
In years ("Y"): 7
In months ("M"): 88
In days ("D"): 2687
In days ignoring months and years ("MD"): 10
In months ignoring days and years ("YM"): 4
In days ignoring years ("YD"): 130
Between: 2020-07-04 and 2026-06-24
In years ("Y"): 5
In months ("M"): 71
In days ("D"): 2181
In days ignoring months and years ("MD"): 20
In months ignoring days and years ("YM"): 11
In days ignoring years ("YD"): 355
Between: 2020-02-29 and 2026-06-24
In years ("Y"): 6
In months ("M"): 75
In days ("D"): 2307
In days ignoring months and years ("MD"): 26
In months ignoring days and years ("YM"): 3
In days ignoring years ("YD"): 116