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?

2 Answers 2


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 WEEKDAY() function:


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:



You can get the weekday as text from a date field by this formula,

=TEXT([DATE_FIELD], "dddd")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.