DATEDIF function
Returns the difference between two dates in days, months or years.
Syntax
=DATEDIF(start_date, end_date, unit)
| Argument | What it means |
|---|---|
start_date | The earlier date. |
end_date | The later date. |
unit | "Y" for years, "M" for months, "D" for days. |
Example
=DATEDIF(B2, TODAY(), "Y")
Whole years between the date in B2 and today, such as an age.
Try itType =DATEDIF( in E2 and click cells to fill in the arguments.
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Item
Qty
Price
Date
Try here
Apples
12
$0.50
2024-01-15
Bananas
30
$0.25
2024-02-29
Cherries
8
$3.20
2024-04-30
Dates
15
$2.75
2024-07-27
Figs
5
$1.90
2024-12-01