convert julian date to calendar date in excel

J

Juan Sanchez

Works for the current year...

If you have your Julian date on A1 then on B1:
=DATE(YEAR(TODAY()),1,0)+A1

It will return the date corresponding to that julian date
on the current year... should be the same exept for leap
years...

Cheers
Juan
 
N

Norman Harker

Hi Charlymon!

If by Julian date you mean the day number of a particular year you can use:

eg For day number 345 in 2004
=DATE(2004,1,345)
Returns: 10-Dec-2004

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top