DatesWork with dates
A date in Excel is a number of days, so you can subtract dates. YEAR, MONTH and DAY take dates apart; DATE builds one.
In which year was order 1001 placed?
A
B
C
D
E
1
Order
Customer
Ordered
Delivered
Year
2
1001
Kim
3/3/25
3/7/25
3
1002
Ali
3/10/25
3/11/25
4
1003
Kim
4/2/25
4/9/25
5
1004
Jo
4/15/25
4/18/25
6
1005
Ali
5/20/25
5/23/25
7