Function reference

TEXT in Excel & Google Sheets

TEXT is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 beginnerBuild a custom TEXT formula →

When to use TEXT

Add a weekday column to a schedule, highlight weekend rows, or show which day of the week transactions occurred.

Worked examples (1)

Date & Timebeginner

Show the day name from a date with TEXT

=TEXT(A2,"DDDD")

Open formula TEXT reference

Common errors with TEXT

Returns "Wednesday" for every row

Make sure you are referencing a date cell, not a text string that looks like a date. Convert text dates with DATEVALUE first.

Language is wrong

TEXT returns day names in the language of your Excel installation. This cannot be changed without a custom formula using CHOOSE and WEEKDAY.

Frequently asked questions

How do I check whether a date falls on a weekend?

Use WEEKDAY(A2,2) which returns 6 for Saturday and 7 for Sunday with Monday=1 numbering. Then use IF(WEEKDAY(A2,2)>5,"Weekend","Weekday").

Need a custom variation?

Describe your specific TEXT problem and get a formula written for your exact data.

Open generator with TEXT