Create a calculated column and input this formula.  I prefer to not have slashes and find periods are easier on the eyes.  You can change the Month and Year to be MM or MMM and YY YYYY respectively.  You can even omit the day.


=TEXT(Date,”mmm.dd.yyyy”)

Go to the main page