Formulyo

Excel + Google Sheets · TEXT

Turn any date into its weekday

Formats a date as text, like the full name of the day.

The formula

=TEXT(A2, "dddd")

What each part means

Example

Before
AB
1DateDay
22026-11-02
32026-11-06
42026-11-14
52026-12-25
After
AB
1DateDay
22026-11-02Monday
32026-11-06Friday
42026-11-14Saturday
52026-12-25Friday

Step by step

  1. Click cell B2.
  2. Type the formula: =TEXT(A2, "dddd")
  3. Press Enter.
  4. Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

The same formula in other languages

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

NETWORKDAYSWorking days left to the deadlineWORKDAYGet the deadline in working daysEOMONTHThe last day of any month, instantlyDATEDIFExcel's hidden formulaSORT + UNIQUEA clean A–Z list in one formulaCOUNTBLANKFind missing data fast