julian dates

L

Lylesm

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 ?
 
R

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 ?
Click to expand...

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
 
L

Lylesm

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

Lylesm

Thanks Ron

Ron Rosenfeld said:
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
Click to expand...
 
Top