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.


2 Answers 2


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, 2019 at 2:03
  • 1
    Welcome. Please have a look at the images. 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 Oct 10, 2020 at 12:58
  • @Nathan One the hidden little gems in Google Sheets. :) Oct 10, 2020 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, 2021 at 17:29

Your Answer

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

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