Is there a way in Excel to convert Julian dates? I have Excel 2000. Thanks in advance. Steve
S Steve Cornelius Oct 1, 2003 #1 Is there a way in Excel to convert Julian dates? I have Excel 2000. Thanks in advance. Steve
J J.E. McGimpsey Oct 1, 2003 #2 For real julian dates (see http://aa.usno.navy.mil/data/docs/JulianDate.html ) just subtract 2415018.5 for the 1900 date system or 2416480.5 for the 1904 date system (adjust for your time zone). For "julian" dates of the form YYddd, check out http://www.cpearson.com/excel/jdates.htm
For real julian dates (see http://aa.usno.navy.mil/data/docs/JulianDate.html ) just subtract 2415018.5 for the 1900 date system or 2416480.5 for the 1904 date system (adjust for your time zone). For "julian" dates of the form YYddd, check out http://www.cpearson.com/excel/jdates.htm
