Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a scheduling analyst preparing 12 dates for a courier-routing tool that needs the day-of-week name ("Monday", "Tuesday", …, "Sunday") alongside each date. The dates in column A are in ISO format (2026-01-15, etc.).
Your task:
The two acceptable patterns:
=TEXT(A2, "dddd") — TEXT formats a date with the format string "dddd" (four ds = full day name). Returns a string.=CHOOSE(WEEKDAY(A2), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday") — WEEKDAY returns 1–7 (Sun=1 by default); CHOOSE picks the matching name. Verbose but explicit.The TEXT-based approach is shorter and locale-aware; the CHOOSE-based approach gives you control over the names (e.g., abbreviated, non-English).
Graded cells: B2 (2026-01-15 → Thursday), B8 (2026-07-04 → Saturday), B12 (2026-11-18 → Wednesday).