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.


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


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.


You can choose and also create your own variations.

enter image description here

  • 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. Oct 8 '19 at 2:03
  • 1
    Welcome. Please have a look at the images. Oct 8 '19 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
    Oct 10 '20 at 12:58
  • @Nathan One the hidden little gems in Google Sheets. :) Oct 10 '20 at 13:15

solution without formatting:


enter image description here

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

  • That's smart; a lot simpler than trying to use WEEKDAY. Jul 26 at 17:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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