Date & time › TEXT71 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeTEXT

TEXT: a spelled-out date for letters

Fajar is preparing catering offer letters with mail merge. The dates in the data show as 19/10/2026, but the letter must spell them out with the weekday and the month name. The date will be joined with other text later, so it has to be text.

Task

Fill B2:B6 with the date from column A as text in a format like Monday, October 19, 2026: weekday, comma, month name, day without a leading zero, comma, year. Use TEXT.

Cells to fillB2:B6

Required functionsTEXT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
TEXT(value, "format_code") turns a number or date into text using a format code, just like cell formatting.
Hint 2
Date codes: dddd = weekday name, mmmm = month name, d = day without a leading zero, yyyy = year. Everything else, such as commas and spaces, appears as typed.
Hint 3
Pattern: =TEXT(A2, "dddd, mmmm …, …").

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

B2:B6

=TEXT(A2,"dddd, mmmm d, yyyy")

Write it in B2, then fill down to B6.

Explanation

=TEXT(A2,"dddd, mmmm d, yyyy") returns the text "Monday, October 19, 2026". Because the result is text, column B can no longer be calculated or sorted as dates, so keep the original dates in column A. For a short form like "Oct 19, 2026", use mmm d, yyyy. To force a language regardless of the computer's settings, put a locale code first, for example [$-421] for Indonesian.

Starting worksheet: Sheet1
Row	A	B
1	Date	Date in the letter
2	19/10/2026
3	02/11/2026
4	25/12/2026
5	01/01/2027
6	17/08/2026
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result