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.
Google Sheets Formulas – How to Show Current Day of the Week
formulasgoogle sheets
Related Topic
- Google Sheets – Display Date of Each Weekday of Current Week
- Google-sheets – Convert cell containing days of the week in first-letter format to day names in Google Sheets
- Google-sheets – How to set Monday as start day of the week in Google Sheets date picker
- Google-sheets – How to determine which working day of the month today is
- Google-sheets – How to open sheets to a specific tab based on days of the week
- Google-sheets – How to change the date to the coming Monday every Friday at 9:30 pm in Google Sheets
- Google-sheets – How to show Day of Week in Order by Day of Week in Google Sheets
Best Answer
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.