how to convert julian date to regular calendar date

R

Ron

I need help converting Julian Date to regular calendar date.
I have from 5000 – 10000 Julian Dates in one column. Ex.
Col A need converted to
4001 = 1 Jan 04
5001 = 1 Jan 05
5030 = 30 Jan 05

Any help would be much appreciated.
Thanks
Ron
 
R

Ron

Thank you Fred, sorry, but I don't understand, is it possible to expand you
explantion some. If I have 5000 Julian dates in column A how would I use your
formula?
Thanks
 
M

Max

Just some implementation assist ..

Assume data is in A1:A5000,

Put in B1 (Fred's formula):
=DATE(INT(A1/1000),1,MOD(A1,1000))

Format B1 as Custom, Type: d-mmm-yy

Copy B1 down to B5000
 

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

Top