<div>
Thanks, this works, and it seems to click now...<br />
SAS is using a Julian base of &nbsp;01-Jan-1960 &nbsp;<br />
This is 21916 days after the Excel base of 00-Jan-1900<br />
Is this correct?<br />

</div>


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?


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to convert a Julian date in Excel that orginated in SAS, but am getting the wrong result by about 50 years. Example:<br />
<br />
SAS Julian date: 12432<br />
Represents: 14-Jan-1994<br />
<br />
In excel by default this instead gives date 13-Jan-1934 &nbsp;(using TEXT(12432,&quot;dd-mmm-yyyy&quot;)<br />
<br />
How can i get Excel to return the required date of 14-Jan-1994 ?<br />
<br />
Thanks!<br />
<br />
<br />
<br />
<br />

</div>
</div>


Hi,

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 ?

Thanks!






Julian date conversion error

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.