It seems like an obvious request, but I could not find an answer.
Within a list, how do I show the day of the week for a date?
More specifically, how to show day of week for a default value for the column?
Using the defined system value,
[TODAY], we can calculate the current date for a default by simply adding:
To get the day of week, use the
Now we have the day number of the week. Using the
TEXT() function we can format it as we please. To get the day of the week, use: