I used the following to convert JD:
=DATE(INT(B5/1000),1,MOD(B5,1000) with first cell of data being B5.
--
Ron


"Ron Coderre" wrote:

Try pointing this formula at your Julian Date:
I used Cell A1:
=DATE(1999+QUOTIENT(A1,1000),12,31)+MOD(A1,1000)

Does that help?
--
Regards,
Ron