Google Sheets - Show the Day of the Week as Text

It can be tricky to display the day of the week on which a particular date falls. This tutorial will walk you through two different ways to do it.

🕒 Timestamps:
0:00 Intro
0:40 With Formatting
1:59 Extract the Day of the Week
3:24 Next Video - Work with Dates and Times

Learn more from Prolific Oaktree:

#googlesheets #dates #day

[MS-zutp]

Just use the simple formula =TEXT(D15, "ddd") (change D15 as needed).

[donaldjones]

Thank you. just what I needed to know.

[deetsbay]

Never knew that Google sheets can do these many things. Really amazing and thanks to you!!! Every video is like a magic trick for me. Learning a lot

[dglearn]

Hi, you are a great man. I love your videos. Good job

[JuanGalva]

Thanks for your content, Oaktree! One question: any chance of using a similar formula (converting numeric dates into text weekdays) to display the day as an abbreviation (only the initial)?

[RonenRothfarb]

Thanks :)
Can I have a different language showing, even if my interface is in English? (trying to show the days in Hebrew)

[davygravy]

I made myself a weekly calendor and id like to make a formula thatll highlight the day of the week it is as i veiw it. So if it were a Wednesday and i look into my weekly schedule it'll highligh the Wednesday column. you know a way i could do that? Thank you!

[sagrindentertainment]

How do you return the month in words using a formula?

[myfailedexperiments]

Hi, this is very helpful. I'm using google sheets to create a chart, but the days can only be sorted as a text, e.g. it starts with "F"Friday, and ends with "W" Wednesday, do you have video tutorial for this?

[RollingCajunOutdoors]

Say I want to enter a date in a row of cells each cell a different date. How do I check to see which day that date is and then if it finds the day of the week it sums up the numbers from another row of cells for only that day? So say I have a roll that has 5/22/22, 5/22/22, 5/24/22, 5/24/22, 5/24/22, 5/24/22, 5/25/22, 5/25/22, 5/25/22 etc and then I have a dollar amount beside each of those in another row so say first roll is A1-A20 and the second row is B1-B20 first row has the dates and second has the dollar values. I want to create 7 columns with the days of the week and I want to sum up all money collected on each day in it's own box with only one function. So I want an average amount of money collected for each day of the week. Pulled from the numbers I enter on my rows.

[FanTazTiCxD]

Girlfriend: "I want you to impress me. Are you good at dates? <3"
Me: "Yes! I've been working with dates in google sheets, ask me anything!"

[AnAlgernon]

It's remarkable that as long as spreadsheets have been around, and as easy as it would be to add a function to return the day of the week as text given a date... that no one at Google has ever added the feature that is trivial and often asked for. Please. Please. If you're a bored developer at Google, ask to work on this. I'm sure there's a an open engineering request from about 10 years ago.