DATE Function
Create dates from year, month, and day components.
Task:
You have year, month, and day values in separate columns. Combine them into proper date values in column D using the DATE function.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of DATE
0/3The same formula in the other shapes it takes at work.
- DATE Function
Create dates from year, month, and day components.
CoreBeginner - DATE rolls over: the first of next month
Month 13 is January of the next year — DATE does the calendar arithmetic for you.
Intermediate - DATE from a yyyymmdd code
Cut the year, month and day out of a text code and rebuild a real date.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Year | Month | Day | Date |
| 2 | 2023 | 1 | 15 | |
| 3 | 2023 | 5 | 20 | |
| 4 | 2023 | 12 | 31 |
Functions used here
What this exercise teachesMay contain the answer
The DATE function creates a valid date from separate year, month, and day values. It's useful for constructing dates from individual components.