software

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 ?

www.cpearson.com/excel/jdates.htm

--
Kind regards,

Niek Otten

quot;Lylesmquot; gt; wrote in message
...
gt;I am trying to covert Julian dates to calendar date and am using the
gt;formula
gt; =DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
gt; shows up as 1900. I don't have any of the transition boxes checked and I
gt; formated the cell using custom d-mmm-yy. Any suggestions ?
On Thu, 5 Jan 2006 09:36:02 -0800, Lylesm gt;
wrote:

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

What does your quot;Julian Datequot; look like?

The quot;realquot; definition is a serial number equal to the number of days elapsed
since January 1, 4713 B.C., proposed by Joseph Scaliger in 1582 and used in
astronomical calculations.

The present Julian Date (5 Jan 2006 18:52:30 UTC) is 2453741.28645833

Probably not what you had in mind :-))

Your formula should work correctly if your quot;Julian Datequot; is a NUMBER made up of
the YEAR followed by the DAY OF THE YEAR.

e.g. for today: 2006005--ron

Actually I figured this out by modifying the formula
=DATE(INT(A4/1000) 105,1,MOD(A4,1000))

quot;Lylesmquot; wrote:

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

Thanks Niek

quot;Niek Ottenquot; wrote:

gt; www.cpearson.com/excel/jdates.htm
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Lylesmquot; gt; wrote in message
gt; ...
gt; gt;I am trying to covert Julian dates to calendar date and am using the
gt; gt;formula
gt; gt; =DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
gt; gt; shows up as 1900. I don't have any of the transition boxes checked and I
gt; gt; formated the cell using custom d-mmm-yy. Any suggestions ?
gt;
gt;
gt;

Thanks Ron

quot;Ron Rosenfeldquot; wrote:

gt; On Thu, 5 Jan 2006 09:36:02 -0800, Lylesm gt;
gt; wrote:
gt;
gt; gt;I am trying to covert Julian dates to calendar date and am using the formula
gt; gt;=DATE(INT(A1/1000),1,MOD(A1,1000)). I am getting the date but the ytear
gt; gt;shows up as 1900. I don't have any of the transition boxes checked and I
gt; gt;formated the cell using custom d-mmm-yy. Any suggestions ?
gt;
gt; What does your quot;Julian Datequot; look like?
gt;
gt; The quot;realquot; definition is a serial number equal to the number of days elapsed
gt; since January 1, 4713 B.C., proposed by Joseph Scaliger in 1582 and used in
gt; astronomical calculations.
gt;
gt; The present Julian Date (5 Jan 2006 18:52:30 UTC) is 2453741.28645833
gt;
gt; Probably not what you had in mind :-))
gt;
gt; Your formula should work correctly if your quot;Julian Datequot; is a NUMBER made up of
gt; the YEAR followed by the DAY OF THE YEAR.
gt;
gt; e.g. for today: 2006005
gt;
gt;
gt; --ron
gt;