julian dates
 

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 ?

julian dates
 

http://www.cpearson.com/excel/jdates.htm

--
Kind regards,

Niek Otten

"Lylesm" wrote in message
...
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 ?

julian dates
 

On Thu, 5 Jan 2006 09:36:02 -0800, Lylesm
wrote:

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 ?

What does your "Julian Date" look like?

The "real" 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 "Julian Date" is a NUMBER made up of
the YEAR followed by the DAY OF THE YEAR.

e.g. for today: 2006005


--ron

julian dates
 

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

"Lylesm" wrote:

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 ?

julian dates
 

Thanks Niek

"Niek Otten" wrote:

http://www.cpearson.com/excel/jdates.htm

--
Kind regards,

Niek Otten

"Lylesm" wrote in message
...
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 ?

julian dates
 

Thanks Ron

"Ron Rosenfeld" wrote:

On Thu, 5 Jan 2006 09:36:02 -0800, Lylesm
wrote:

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 ?

What does your "Julian Date" look like?

The "real" 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 "Julian Date" is a NUMBER made up of
the YEAR followed by the DAY OF THE YEAR.

e.g. for today: 2006005


--ron