Use the solution below if you are asked to provide a column in a SharePoint custom list that displays the day of the week based on another column that contains an actual date.
In the example to the left, the first column (Date) displays a date in the M/D/YYYY format, while the second column (Day) displays the day of the week for the date to the left.
The column to the left consists of a Calculated column.
The column to the left consists of a Calculated column.
The formula needed to translate the information in the Date column is:
=TEXT(WEEKDAY([Date]),"dddd")
Just replace Date with the (internal) name for the column applicable to your own list.
Use dddd to display the full name of the week (for example, 'Sunday').
Use ddd to display the abbreviated name of the week (for example, 'Sun').
RSS Feed