ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
1/1/1965
2
10/23/2024
3
4
21845
=DATEDIF(A1,A2,"d")
 Fill in "d" for the third argument to get the number of days between two dates
5
717
=DATEDIF(A1,A2,"m")
 "m" for the third argument to get the number of months between two dates.
6
59
=DATEDIF(A1,A2,"y")
 Fill in "yd" for the third argument to ignore years and get the number of days between two
7
295
=DATEDIF(A1,A2,"yd")
Fill in "yd" for the third argument to ignore years and get the number of days between two dates.
8
22
=DATEDIF(A1,A2,"md")
md" for the third argument to ignore months and get the number of days 
9
9
=DATEDIF(A1,A2,"ym")
"ym" for the third argument to ignore years and get the number of months between two dates.
10
11
12
13
14
15
16
17
18
19
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101