Excel - Day of year to date format

[Bren.ie]

Is it possible to convert day of year to date format (assuming all date
are 2004)
e.g. 001 to 01 January 2002
or 366 to 31 December 200

 

[Frank Kabel]

Hi
try
=DATE(2004,1,your_value)

Frank

 

[Bren.ie]

Thanks Frank this works perfectl