how to convert date serial number to regular date?

[union]

i was just wondering what is the formula to convert a date serial number back to an actual date?

[Pete_UK]

You need to format the cell as a date in the style that you prefer, i.e. right-click on the cell and choose Format Cells, then on the Number tab choose Date from the list then select the format.

Hope this helps.

Pete