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 ?