SharePoint Document Issues

Display a SharePoint List Date as DD-MMM-YY

Rana GarciaRana Garcia Nov 13, 2026 868 views

Question details

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

Display a SharePoint List Date as DD-MMM-YY
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.
Before you start

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.

Solution 1Recommended

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.

1
Open column settings

Open the SharePoint list, select Settings, and then select List settings. Choose Create column.

2
Choose a calculated column

Enter a name such as Formatted Date and select Calculated (calculation based on other columns) as the column type.

3
Enter the formula

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.

4
Save and check the result

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.

Create a calculated column for the formatted date
Keep the original date column: The calculated result is text, so sorting it may not produce chronological order. Use the original Date and Time column for date-based sorting and filtering.
Free Microsoft Office alternative

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.

Apply custom date formats such as dd-mmm-yy in a spreadsheetOpen and save Microsoft Excel XLSX filesWork with a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.