In OpenOffice Calc, you can use the DATEVALUE formula code to automatically display dates in different ways.