Dashboard Mode - DATE function construction
Dashboard Goal
Help users understand how to build dates using the DATE function in Excel by combining year, month, and day values.
0
0
DATE function construction in Excel - Dashboard Guide
Sample Data
| Year | Month | Day | Event |
|---|---|---|---|
| 2024 | 6 | 15 | Project Start |
| 2024 | 7 | 1 | Milestone 1 |
| 2024 | 8 | 30 | Milestone 2 |
| 2024 | 12 | 31 | Project End |
| 2025 | 1 | 10 | Review Meeting |
Dashboard Components
- KPI Cards: Show full date constructed from year, month, and day using
=DATE(A2,B2,C2)for each row. - Table: Displays original data plus a new column Full Date with the constructed date formatted as
MMMM DD, YYYY. - Formula Explanation:
DATE(year, month, day)combines separate numbers into a valid date.
| Year | Month | Day | Event | Full Date (Formula) |
|---|---|---|---|---|
| 2024 | 6 | 15 | Project Start | =DATE(A2,B2,C2) -> 6/15/2024 |
| 2024 | 7 | 1 | Milestone 1 | =DATE(A3,B3,C3) -> 7/1/2024 |
| 2024 | 8 | 30 | Milestone 2 | =DATE(A4,B4,C4) -> 8/30/2024 |
| 2024 | 12 | 31 | Project End | =DATE(A5,B5,C5) -> 12/31/2024 |
| 2025 | 1 | 10 | Review Meeting | =DATE(A6,B6,C6) -> 1/10/2025 |
Dashboard Layout
+----------------------+-----------------------------+ | KPI Cards | Full Date Table | | (Dates from DATE()) | (Original + Full Date col) | +----------------------+-----------------------------+
Interactivity
Users can change the year, month, or day values in the table cells. The DATE function automatically updates the full date shown in the new column and KPI cards. This helps users see how changing parts of a date affects the full date.
Self Check
If you change the month value in row 3 from 7 to 9, which components update?
- The Full Date column in the table updates to show the new date (September 1, 2024).
- The KPI card for that row updates to show the new date.
Key Result
Dashboard shows how to build full dates from year, month, and day using the DATE function in Excel.