http://www.cpearson.com/excel/jdates.htm

--
Kind regards,

Niek Otten

"Lylesm" wrote in message
...
I am trying to covert Julian dates to calendar date and am using the
formula
=DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
shows up as 1900. I don't have any of the transition boxes checked and I
formated the cell using custom d-mmm-yy. Any suggestions ?