If you have dates in Excel then you may want to see what day of the week it is. You can do this by using the the Weekday function, this will show you the day of the week as a number but you can display it as the actual word. Here Gary Schwartz from shows us how.
Xem thêm bài viết: https://sylvaniachristian.com/category/cong-nghe
34 thoughts on “Excel: How to Show the Day of the Week for a Date – Weekday Function”
Thanks for this, it was driving me bonkers!
Thanks a lot!
U showed me what exactly I wanted to learn
PERFECT video, thanks!! 😁
thanks a lot
thank you! very helpful 🙂
Awesome! Thank you so much!!
perfect! nice and easy. Thank you!
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?
MANY MANY THANKS! I watched a bunch of other vids on this in total frustration. You made it so simple!
thx. very good explained
thank you, this was so helpful and calmly explained!
THANK YOU 1×10^6 times
Thank you…. perfect..
Its helpful video, I was searching on net how to show the days, only your video is clear and right, thanks for your video
This did not work for me. Instead of a number ie "6" I got "=WEEKDAY(A18)". I am using Excel 2007. The date was in the cell above what I wanted to use as the weekday display cell, otherwise I followed everything in the guide exactly.
Excellent, thank you.
Thank you very much
Thank you very much, my friend. To the point and exactly what I was looking for. Thumbs Up for sure!
Just typing in a particular cell with the reference is little bit easier
Eg. =TEXT(A1,"dddd") where A1 is the particular date.
If I am given a week number. How do I convert to dates?
can you teach me how to make sheet to day1-day 31
Hi! i followed your instructions but instead of the day of the week coming up, Im getting a random date and time. do you have any idea why ?
looking for how I could take the date the computer knows and tell me what next Sunday is …
Thank you, so much :).
thanks for this
exactly what I needed….thanks a lot…
Very nice tutorial!! This is exactly what I needed. 🙂
Excellent! Just what I needed