Sheetsdrill

Level 5: Text and dates Exercise 90 of 92

Day of the week as a word

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Show the day of the week of each date as a full word, such as Thursday. Fill B2 and B3 using TEXT.

What this exercise teaches

WEEKDAY returns a number, which is what calculations need. TEXT with dddd returns the name, which is what a schedule or a report needs.

A hint if you get stuck

In a TEXT format, dddd is the full day name and ddd the short one.

Functions used: TEXT

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Text and dates