TEXT formatting for dates in Excel - Dashboard Guide

Dashboard Mode - TEXT formatting for dates

Dashboard Goal

Show different ways to display dates using Excel's TEXT function for easy reading and reporting.

Sample Data

Date	Event
2024-01-15	Project Start
2024-02-28	First Review
2024-03-10	Mid Project
2024-04-25	Final Submission
2024-05-05	Project Close

Dashboard Components

• KPI Card 1: Original Date
  Shows the raw date from the data.
  Formula: =A2 (copy down)
• KPI Card 2: Date as "MMMM DD, YYYY"
  Shows date as full month name, day, and year.
  Formula: =TEXT(A2,"MMMM dd, yyyy")
• KPI Card 3: Date as "DD-MMM-YY"
  Shows date as day, short month name, two-digit year.
  Formula: =TEXT(A2,"dd-mmm-yy")
• KPI Card 4: Date as "ddd, MMM DD"
  Shows abbreviated weekday, short month, and day.
  Formula: =TEXT(A2,"ddd, MMM dd")
• KPI Card 5: Year Only
  Extracts and shows only the year.
  Formula: =TEXT(A2,"yyyy")

Dashboard Layout

+----------------+---------------------------+
| Original Date  | Date as "MMMM DD, YYYY"   |
| (Raw)          |                           |
+----------------+---------------------------+
| Date as "DD-   | Date as "ddd, MMM DD"     |
| MMM-YY"        |                           |
+----------------+---------------------------+
| Year Only                      |
+-------------------------------+

Interactivity

Add a filter to select events by month or year. When you pick a month or year, all date formats update to show only dates for that selection. This helps compare how dates look in different formats for the chosen time.

Self Check

If you add a filter to show only events in March 2024, which dates appear in each component? Answer: Only the row with date 2024-03-10 will show in all date format cards.

Key Result

Dashboard showing Excel TEXT function formatting for dates in multiple styles.