convert julian date to calendar date in excel

  • Thread starter Thread starter charlymon
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top