8

I have a Google Sheets that works as my To-Do list, and I want to make a cell that displays the current day of the week in text and updates itself every day. For example, Monday or Friday.

Improve this question
0

2 Answers 2

Reset to default
5

There is a build-in function for that in Google Sheets.

=today()

Just write that in a cell of your choice. You only then need to format the cell and display the date as you like by going to Menu--> Format --> Number --> More Formats --> More date and time formats.

date-01

You can choose and also create your own variations.

enter image description here

Improve this answer
4
  • What I meant is that it would show the name of the day of the week, for example, Monday or Friday. My bad for not elaborating.
    – gameyall232
    Oct 8, 2019 at 2:03
  • 1
    Welcome. Please have a look at the images.
    – marikamitsos
    Oct 8, 2019 at 2:18
  • It's great how much you can customize within that sub-menu "format: ... "more date and time formats" " ! Saved me a lot of time and headache
    – Nathan majicvr.com
    Oct 10, 2020 at 12:58
  • @Nathan One the hidden little gems in Google Sheets. :)
    – marikamitsos
    Oct 10, 2020 at 13:15
12

solution without formatting:

=Text(TODAY(),"dddd")

enter image description here

see https://support.google.com/docs/answer/3094139

Improve this answer
1
  • That's smart; a lot simpler than trying to use WEEKDAY.
    – Zsolt Safrany
    Jul 26, 2021 at 17:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.