Julian date conversion error


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
Represents: 14-Jan-1994

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 ?


Who is Participating?
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:

Or, enter 21916 in a free cell, select the cell, press CTRL=C, select all of the date values to be adjusted, choose the menu command Edit->Paste Special, select Add, click OK. Once the date values are fixed you can format the cells as dates.

xeniumAuthor Commented:
Thanks, this works, and it seems to click now...
SAS is using a Julian base of  01-Jan-1960  
This is 21916 days after the Excel base of 00-Jan-1900
Is this correct?
zorvek (Kevin Jones)ConsultantCommented:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.