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
More Formats -->
More date and time formats.
You can choose and also create your own variations.