DATEDIF

Date/Time Functions:
Function: DATEDIF() - Calculates the number of days, months, or years between two dates.
Between: 1900-01-01 and 2026-11-15
In years ("Y"): 126
In months ("M"): 1522
In days ("D"): 46340
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 10
In days ignoring years ("YD"): 318
Between: 1904-01-01 and 2026-11-15
In years ("Y"): 122
In months ("M"): 1474
In days ("D"): 44879
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 10
In days ignoring years ("YD"): 319
Between: 1936-03-17 and 2026-11-15
In years ("Y"): 90
In months ("M"): 1087
In days ("D"): 33115
In days ignoring months and years ("MD"): 29
In months ignoring days and years ("YM"): 7
In days ignoring years ("YD"): 243
Between: 1960-12-19 and 2026-11-15
In years ("Y"): 65
In months ("M"): 790
In days ("D"): 24072
In days ignoring months and years ("MD"): 27
In months ignoring days and years ("YM"): 10
In days ignoring years ("YD"): 331
Between: 1999-12-31 and 2026-11-15
In years ("Y"): 26
In months ("M"): 322
In days ("D"): 9816
In days ignoring months and years ("MD"): 15
In months ignoring days and years ("YM"): 10
In days ignoring years ("YD"): 319
Between: 2000-01-01 and 2026-11-15
In years ("Y"): 26
In months ("M"): 322
In days ("D"): 9815
In days ignoring months and years ("MD"): 14
In months ignoring days and years ("YM"): 10
In days ignoring years ("YD"): 319
Between: 2019-02-14 and 2026-11-15
In years ("Y"): 7
In months ("M"): 93
In days ("D"): 2831
In days ignoring months and years ("MD"): 1
In months ignoring days and years ("YM"): 9
In days ignoring years ("YD"): 274
Between: 2020-07-04 and 2026-11-15
In years ("Y"): 6
In months ("M"): 76
In days ("D"): 2325
In days ignoring months and years ("MD"): 11
In months ignoring days and years ("YM"): 4
In days ignoring years ("YD"): 134
Between: 2020-02-29 and 2026-11-15
In years ("Y"): 6
In months ("M"): 80
In days ("D"): 2451
In days ignoring months and years ("MD"): 17
In months ignoring days and years ("YM"): 8
In days ignoring years ("YD"): 260