Dashboard Mode - TEXT formatting for dates
Goal
Show how to display dates in different text formats using the TEXT function in Google Sheets.
0
0
TEXT formatting for dates in Google Sheets - Dashboard Guide
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
- Original Date Column: Shows raw dates from A2:A6.
- Formatted Date - Full Month Name: Uses
=TEXT(A2,"mmmm dd, yyyy")to show dates like "January 15, 2024". - Formatted Date - Short Date: Uses
=TEXT(A2,"mm/dd/yy")to show dates like "01/15/24". - Formatted Date - Day and Month: Uses
=TEXT(A2,"ddd, mmm d")to show dates like "Mon, Jan 15". - Formatted Date - Year Only: Uses
=TEXT(A2,"yyyy")to show just the year like "2024".
Dashboard Layout
+----------------+--------------------------+----------------+---------------------+-----------------+ | Original Date | Full Month Name Format | Short Date | Day and Month Format | Year Only | +----------------+--------------------------+----------------+---------------------+-----------------+ | 2024-01-15 | January 15, 2024 | 01/15/24 | Mon, Jan 15 | 2024 | | 2024-02-28 | February 28, 2024 | 02/28/24 | Wed, Feb 28 | 2024 | | 2024-03-10 | March 10, 2024 | 03/10/24 | Sun, Mar 10 | 2024 | | 2024-04-25 | April 25, 2024 | 04/25/24 | Thu, Apr 25 | 2024 | | 2024-05-05 | May 05, 2024 | 05/05/24 | Sun, May 5 | 2024 | +----------------+--------------------------+----------------+---------------------+-----------------+
Interactivity
Adding a filter by Event name will update all formatted date columns to show only the selected events' dates in their respective formats.
Self Check
If you add a filter to show only "Mid Project" and "Final Submission" events, which rows and formatted dates remain visible in the dashboard?
Key Result
Dashboard showing original dates and their different text formats using the TEXT function in Google Sheets.