Change Date Format of Site Column

Formatted date in sharepoint list

Formatted date in sharepoint list

Formatted date in sharepoint list

Formatted date in sharepoint list

First of all create a column with column type, choose Date Only radio button under Date and Time Format provide the column name as ‘Date’

Then Create one more column with Calculated (calculation based on other columns) column type, provide the below said formulas in formula input fields and name the column as ‘Custom Date’

After creating the columns try to enter date from new item form and submit, then you can view the date formatted as shown in Output column below

Formula (calculation based on other columns) Output
=TEXT(Date,”dd Mmm, yyyy”) 27 Mar, 2008
=TEXT(Date,”d/m/yyyy”) 21/7/2008