julian dates

[Guest]

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 ?

 

[Niek Otten]

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

 

[Ron Rosenfeld]

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

 

[Guest]

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

 

[Guest]

Thanks Niek

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

 

[Guest]

Thanks Ron

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