Julian Date

[MaryV]

Can someone please tell me how I can convert a Julian date that read
(example):

32803 meaning the 328th day of the year 2003 to what should b
11/24/03

Thanks in advance.....

 

[Niek Otten]

There are several "definitions" of Julian dates. Although yours differs
slightly from the one used in this example, this link might still put you on
the right track

http://www.cpearson.com/excel/jdates.htm
--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

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

 

[Ron Rosenfeld]

32803

You only show a two digit year, so the actual year is ambiguous. If the year
must be in the 21st century, then:

=DATE(2000+MOD(G1/100,1)*100,1,INT(G1/100))

If your two digit years go from 1930 to 2029, then:

=DATE(1900+MOD(G1/100,1)*100+100*(MOD(G1/100,1)<0.03),1,INT(G1/100))


--ron