You can just add the number of days to the last day of the previous year.

Example:
="12/31/2005" + I4 would yield the date in 2006 according to the value in I4
(when formatted as a date, of course).

Will

" 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.