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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moon phases and julian dates 0
Change satellite julian date format YYYYDDDHHMMSS to excel date ti 1
convert Julian date to DD/MM/YYYY 7
How to Convert a Julian Date to Calendar Date 2
julian date 1
Dates from Julian calendar 1
Three Digit Julian Date 4
how to convert from julian date to mm/dd/year 6

Back
Top