Converting Excel Serial Number to Date

[ggranger007]

How do I convert an Excel serial number (i.e. 39577) to a date (i.e. 5/22/08) using Excel formulas? I don't have the option of just changing the formatting.

Edit, nevermind, I found a simple way to do what I need.

 

[schielrn]

Try:

=date(year(a1),month(a1),day(a1))

OR:

=text(a1,"m/d/yy")

Hope that helps.