How to: Listing the Name of the Day of the Week (e.g. "Monday", "Tuesday", etc.)

Does anyone know the formula for converting a date to the name of the weekday? I have a nicely formatted column with the dates of meetings on them, but was hoping to add a column that lists them by the name of the day (e.g. 1/8/20 = “Wednesday”). I go to a lot of meetings and my brain just processes things better with words rather than numbers.


Try this formula:

=WeekdayName([your date field goes here])

I use this regularly. If it doesn’t work go to Coda’s formula page for more reference on this formula.

1 Like

Thanks! That did it!

1 Like