🎨 Date Formatter

Goal: Turn a date serial number into readable text.
TEXT creates a String, meaning you can concatenate it with other words easily.

Raw Serial (Oct 25) 45955
âŦ‡
"dd-mmm-yy"
âŦ‡
-
Ready...

đŸ’ģ Formula Structure

=TEXT(value, format_text)
  • 1. Value: The date serial number (or cell reference).
  • 2. Format Text: The pattern string (e.g., "dd/mm/yy").
-- Format Date as Text
=TEXT( 45955, "dd-mmm-yy" )
Final Text:
-

ℹī¸ Date Codes Cheat Sheet

d
Day number (1-31)
dd
Day w/ zero (01-31)
ddd
Short Day (Mon)
dddd
Full Day (Monday)
mmm
Short Month (Oct)
yyyy
Full Year (2025)