SSW Foursquare

Do you know how to format dates to include the weekday in SharePoint?

Format dates to include weekdays using calculated columns and formulas in SharePoint.

Figure: Bad example - Using the default Date Format

Figure: Good example - Using the Date Format with 'ddd'

How do you do this?

By default, the date type column only have two format options:

Figure: Date Format #1

Figure: Date Format #2

To add the week day(eg.Wed) you need to:

  1. Select List Settings | Columns |Create column | Calculated (calculation based on other columns)
  2. See the columns of this list in the "Insert Column", add the column you want to change format, and custom the code in "Formula" like below:

Figure: Calculated column with Formula code

  1. Change the views of the list to use the new Calculated column (WeekDate) instead of the original date column (Date):

Figure: Replace the old Date column (Date) with new Calculated column (WeekDate It should not be this hard)

William Yin
SharePoint for Developers
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS