how to convert julian date to regular calendar date

[Guest]

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

 

[Fred Smith]

Use the formula =Date(int(a1/1000),1,mod(a1,1000))

 

[Guest]

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

 

[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

 

[Guest]

Thank your Max, you explained so even I got it to work! Thank YOU!

 

[Max]

Glad to hear that <g> !
Thanks for the feedback ..