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

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Ron" wrote in message
...
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

--
Ron