Assume the serial is in A1

=A1/86400+DATE(1970,1,1)

ut will give you time as well but if you format it as
dd/mm/yy it will display your date, if you want the pure date from midnight
on that date use

=INT(A1/86400+DATE(1970,1,1))

the reason you get time is that the serial date is seconds since 1/1/1970



Regards,

Peo Sjoblom

"Judy" wrote:

What is the formula for converting a date stored as a serial number in Excel
spreadsheet with Epoch date of 1/1/70 to a month,day, year? Example: Serial
date 1103033227 converts to 12/14/04.

Thanks. I appreciate any help.