Assumint numbers are in Column A, and you want dates for THIS year, put this
in B1 ad copy down..........

=DATEVALUE(12&"/"&31&"/"&YEAR(TODAY()))-365+A1

Vaya con Dios,
Chuck, CABGx3



" wrote:

Hi NG,

Is there a function in Excel that returns the date when given the
number of the day in the year (i.e. 1-365)?

All help is greatly appreciated. Thanks in advance!

Best,

M.L.