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
(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

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
Three Digit Julian Date 4
convert Julian Date Format to Excel 1
Convert julian date 14
how to convert from julian date to mm/dd/year 6

Top