I need to convert a Julian date in Excel that orginated in SAS, but am getting the wrong result by about 50 years. Example:
SAS Julian date: 12432
In excel by default this instead gives date 13-Jan-1934 (using TEXT(12432,"dd-mmm-yyyy")
How can i get Excel to return the required date of 14-Jan-1994 ?