julian date

[Guest]

How do you convert a julian date back to a calender date??

 

[Gary Brown]

When you say Julian Date, do you mean a number like 38353. When you say
calendar date, do you mean something like 01/01/2005? If so, this sounds
like a formatting question.
Put your cursor on the cell with the Julian Date. Select FORMAT / CELLS /
NUMBER / DATE. Then in the 'Type:' window, select the desired format.
HTH,
Gary Brown

 

[Dave Peterson]

Depends on what you mean.

If you mean you have cells with values like:
yyyyddd
2005032 is equivalent to Feb 1, 2005
then
=DATE(A1/1000,1,MOD(A1,1000))

If you have
yyddd
then this may work for you:
=DATE(IF(A1<30000,2000,1900)+A1/1000,1,MOD(A1,1000))

 

[Norman Jones]

Hi Jason,

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

 

[Ron Rosenfeld]

How do you convert a julian date back to a calender date??

First you have to tell us what you mean by a julian date.

The dictionary 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: January 1, 1965, at noon, Greenwich Civil Time, was Julian Day
2,438,762.0"

but sometimes different definitions are used here.


--ron