Is there a good way to convert a date to the day of the week?
For example, if the date is 8/3/2021, I want to convert that to Tuesday.
If the date is 8/4/2021, I want to convert that to Wednesday. Etc.
I recommend checking out the reference table at the bottom of the Format Dates page. This table gives you a comprehensive overview of all of the different ways to format dates.
To convert a date to the day of week, we can set the new format to be ‘dddd’:
Hope this helps – let me know if you have any other questions!