Display a SharePoint List Date as DD-MMM-YY
Question details
The user wants to display a SharePoint list date in the format DD-MMM-YY, such as 14-Jun-20.

- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- The user needs a custom date display that is not available in the standard Date and Time column settings.
- Observed behavior
- The desired display is a two-digit day, abbreviated month, and two-digit year separated by hyphens.
Identify the existing Date and Time column in your list and confirm that you have permission to add columns. Check the list's regional settings if you need English month abbreviations.
Create a calculated column for the formatted date
Use a calculated text column to display the date as DD-MMM-YY without changing the original Date and Time column.
Open the SharePoint list, select Settings, and then select List settings. Choose Create column.
Enter a name such as Formatted Date and select Calculated (calculation based on other columns) as the column type.
In the Formula box, enter =TEXT([Date],"dd-mmm-yy"), replacing Date with the name of your existing Date and Time column. Select the column from the available columns list if needed.
Under the return type, select Single line of text, then select OK or Save. Check a list item to confirm that its date appears in a form such as 14-Jun-20.

Format dates in a spreadsheet with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easy transition. Use WPS Spreadsheets to format dates in a spreadsheet copy; it does not change the SharePoint list's column settings.

Frequently Asked Questions
Can I apply DD-MMM-YY directly in the SharePoint Date and Time column settings?
The standard Date and Time column settings do not provide this custom format directly. Create a calculated column and use =TEXT([Date],"dd-mmm-yy") instead.
Will the calculated column change my original date?
No. The formula reads the original Date and Time column and displays a separate text result. You can keep the original column for date-based sorting and filtering.
Why does the month abbreviation appear in another language?
Month abbreviations can depend on regional settings. Check the site's regional settings if you need an English abbreviation such as Jun.
Can I sort the formatted dates chronologically?
The calculated column returns text, so its sort order may not be chronological. Sort by the original Date and Time column instead.




