Excel: How to Show the Day of the Week for a Date - Weekday Function

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

[mitchellrorke]

Thank youuu.. You don't know how much time you've saved me.

[orangequant]

MANY MANY THANKS! I watched a bunch of other vids on this in total frustration. You made it so simple!

[christopliss]

Brilliant!!! Saved me loads of time. Very good lesson.

[JB-pkvc]

Thanks for this, it was driving me bonkers!

[naslan]

Just saved me two hours of work, man. Thanks!

[clivewhitworth]

thank you! Saved a lot of time and head scratching

[CerebralPrimate]

Thank you very much, my friend. To the point and exactly what I was looking for. Thumbs Up for sure!

[rajaasam]

Its helpful video, I was searching on net how to show the days, only your video is clear and right, thanks for your video

[hicksy]

Thanks for the easy to understand video, but if you delete the date the cell with the day in defaults to Saturday how can I change it so it will display nothing?

[katherinewhitaker]

thank you, this was so helpful and calmly explained!

[garmit]

You could also define the cell holding the date as ddd, dd/mmmm/yy or replace the '/' with whichever delimiter you want

[Jane_Ricciardi]

Very nice tutorial!! This is exactly what I needed. :-)

[diduschannel]

thanks for video, was helpful for me!

[imranali-rrvv]

you are a lifesaver. Thanks for this ;)

[adee]

Just typing in a particular cell with the reference is little bit easier
Eg. =TEXT(A1, "dddd") where A1 is the particular date.

[Sumitdharewa]

exactly what I needed....thanks a lot...