Exercises / Dates and deadlines · 1 of 10
Build a date from year, month and day
Excel stores a date as a number: the days since 1 January 1900. DATE(year, month, day) builds that number from its parts, so it can be sorted, subtracted and formatted.
Your taskAn export split each date into three columns. In D2, use DATE to build the date from the year in A2, the month in B2 and the day in C2. It will be copied down to D7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Year | Month | Day | Date |
| 2 | 2026 | 1 | 15 | |
| 3 | 2026 | 3 | 2 | |
| 4 | 2026 | 4 | 30 | |
| 5 | 2026 | 7 | 9 | |
| 6 | 2026 | 10 | 1 | |
| 7 | 2026 | 11 | 23 |