DATEDIF

Date/Time Functions:
Function: DATEDIF() - Calculates the number of days, months, or years between two dates.
Between: 1900-01-01 and 2026-08-28
In years ("Y"): 126
In months ("M"): 1519
In days ("D"): 46261
In days ignoring months and years ("MD"): 27
In months ignoring days and years ("YM"): 7
In days ignoring years ("YD"): 239
Between: 1904-01-01 and 2026-08-28
In years ("Y"): 122
In months ("M"): 1471
In days ("D"): 44800
In days ignoring months and years ("MD"): 27
In months ignoring days and years ("YM"): 7
In days ignoring years ("YD"): 240
Between: 1936-03-17 and 2026-08-28
In years ("Y"): 90
In months ("M"): 1085
In days ("D"): 33036
In days ignoring months and years ("MD"): 11
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 164
Between: 1960-12-19 and 2026-08-28
In years ("Y"): 65
In months ("M"): 788
In days ("D"): 23993
In days ignoring months and years ("MD"): 9
In months ignoring days and years ("YM"): 8
In days ignoring years ("YD"): 252
Between: 1999-12-31 and 2026-08-28
In years ("Y"): 26
In months ("M"): 319
In days ("D"): 9737
In days ignoring months and years ("MD"): 28
In months ignoring days and years ("YM"): 7
In days ignoring years ("YD"): 240
Between: 2000-01-01 and 2026-08-28
In years ("Y"): 26
In months ("M"): 319
In days ("D"): 9736
In days ignoring months and years ("MD"): 27
In months ignoring days and years ("YM"): 7
In days ignoring years ("YD"): 240
Between: 2019-02-14 and 2026-08-28
In years ("Y"): 7
In months ("M"): 90
In days ("D"): 2752
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 6
In days ignoring years ("YD"): 195
Between: 2020-07-04 and 2026-08-28
In years ("Y"): 6
In months ("M"): 73
In days ("D"): 2246
In days ignoring months and years ("MD"): 24
In months ignoring days and years ("YM"): 1
In days ignoring years ("YD"): 55
Between: 2020-02-29 and 2026-08-28
In years ("Y"): 6
In months ("M"): 77
In days ("D"): 2372
In days ignoring months and years ("MD"): 30
In months ignoring days and years ("YM"): 5
In days ignoring years ("YD"): 181