try this formula or a macro to do it for you.
=DATEVALUE(12&"/"&31&"/"&YEAR(TODAY()))-365+A1

--
Don Guillett
SalesAid Software

"Birmangirl" wrote in message
...
I'm using XL2003. For manufacturing purposes, products are stamped with a
serial number that includes the day of manufacture, represented by the day
number, i.e. January 1st = 001, 1st February = 032 and so on. Each new
year
begins again at 001.
Is there a quick way to convert this 3-digit day number to an actual date?
Thanks in advance,
Amanda