Build a date from separate parts with DATE
BeginnerSometimes dates are stored with the year, month, and day in separate columns instead of as one real date. Excel needs a single date value to sort, filter, or calculate with those dates.
The DATE function solves this. It takes three numbers and returns a proper Excel date:
=DATE(year, month, day)
For example, =DATE(2024, 6, 1) returns June 1, 2024.
What you need to do:
- Click cell E2.
- Write a DATE formula that combines the year in column B, the month in column C, and the day in column D for that row.
- Press Enter. The cell should display a date.
- Copy the formula down from E2 through E7.
Need some help?
Hint 1
The DATE function takes three arguments in order: year, month, day. Each should reference the corresponding column in the same row.
Hint 2
Your formula in E2 needs one cell reference from each of columns B, C, and D, in the order DATE expects them: year first, then month, then day. Once it works for row 2, copy it down through E7.
Build a date from separate parts with DATE
BeginnerSometimes dates are stored with the year, month, and day in separate columns instead of as one real date. Excel needs a single date value to sort, filter, or calculate with those dates.
The DATE function solves this. It takes three numbers and returns a proper Excel date:
=DATE(year, month, day)
For example, =DATE(2024, 6, 1) returns June 1, 2024.
What you need to do:
- Click cell E2.
- Write a DATE formula that combines the year in column B, the month in column C, and the day in column D for that row.
- Press Enter. The cell should display a date.
- Copy the formula down from E2 through E7.
Need some help?
Hint 1
The DATE function takes three arguments in order: year, month, day. Each should reference the corresponding column in the same row.
Hint 2
Your formula in E2 needs one cell reference from each of columns B, C, and D, in the order DATE expects them: year first, then month, then day. Once it works for row 2, copy it down through E7.