BBampaa

Lessons › Excel & Google Sheets

Excel & Google Sheets lesson

Weekday names with TEXT

"dddd" gives the full weekday: Friday.

Try this lesson free →
About 5–10 minutes · no sign-up needed

Example

TEXT turns a date into words, using a format code in quotes:

=TEXT(B2,"dddd")

Typed into cell D2 of this sheet:

OrderOrderedDeliveredWeekdayMonth
O101{'date': '2024-03-01'}{'date': '2024-03-04'}
O102{'date': '2024-03-04'}{'date': '2024-03-08'}
O103{'date': '2024-03-05'}{'date': '2024-03-06'}
O104{'date': '2024-03-07'}{'date': '2024-03-14'}
O105{'date': '2024-03-11'}{'date': '2024-03-13'}

Key points

TEXT(B2,"dddd")The full weekday name: Friday.
"ddd"Three letters: Fri.
TEXT(B2,"mmmm")The same idea for months: March.

Put together: =TEXT(B2,"dddd"). The format code always goes in quotes.

Practice

Try each one in your head first, then open the answer.

1. In D3, show which weekday order O102 was placed.
=TEXT(B3,"dddd")
2. In E2, show the month name of order O101.
=TEXT(B2,"mmmm")
3. In D4, show the weekday order O103 was placed.
=TEXT(B4,"dddd")
4. In D5, show the short weekday (three letters) order O104 was placed.
=TEXT(B5,"ddd")
5. In D6, show the weekday order O105 was delivered.
=TEXT(C6,"dddd")

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed