T
Talltrees
How do you select Julian dates and not regular month and days?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
J
JE McGimpsey
Julian dates are dates that start on January 1, 4713 BCE at noon in
Greenwich, so today's date is 2453071. To get Julian dates, just add
2415018.5 for the 1900 date system or 2416480.5 for the 1904 date system
(adjust for your time zone).
You can find out more about Julian dates here:
http://aa.usno.navy.mil/data/docs/JulianDate.html
For so-called "julian" dates of the form YYddd, check out
http://www.cpearson.com/excel/jdates.htm
Greenwich, so today's date is 2453071. To get Julian dates, just add
2415018.5 for the 1900 date system or 2416480.5 for the 1904 date system
(adjust for your time zone).
You can find out more about Julian dates here:
http://aa.usno.navy.mil/data/docs/JulianDate.html
For so-called "julian" dates of the form YYddd, check out
http://www.cpearson.com/excel/jdates.htm
B
Bob Phillips
Tools>Options>Calculation and select 1904 Date system checkbox.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
N
Norman Harker
Hi Talltrees!
If by Julian dates you mean the day number in the year, you need to
use a formula:
=A1-DATE(YEAR(A1)-1,12,31)
But if you are referring to the correct definition use:
=IF(MOD(A1,1)<0.5,A1+2415018,A1+2415019)
Julian Dates start at 12:00 Noon and are number of days from
1-Jan-4173 BCE (Julian Calendar)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
If by Julian dates you mean the day number in the year, you need to
use a formula:
=A1-DATE(YEAR(A1)-1,12,31)
But if you are referring to the correct definition use:
=IF(MOD(A1,1)<0.5,A1+2415018,A1+2415019)
Julian Dates start at 12:00 Noon and are number of days from
1-Jan-4173 BCE (Julian Calendar)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
T
Talltrees
Thanks for the information. I did not know Julian meant the Julian Calendar.
I have a sheet that tells me the day number in the year, but I thought a
spreadsheet I used in the past had it in formating. Thanks again.
I have a sheet that tells me the day number in the year, but I thought a
spreadsheet I used in the past had it in formating. Thanks again.
N
Norman Harker
Hi Talltrees!
There's no format that gives you the day number of the year, other
than dd which would only work for the month of January. We don't even
have a built in or Analysis ToolPak function. You could use the UDF to
get the day in the year:
Function DAYINYEAR(DateForNumber As Date) As Integer
DAYINYEAR = DateForNumber - DateSerial(Year(DateForNumber), 1, 0)
End Function
Maybe one of the other spreadsheet programs has it as a format or
function.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
There's no format that gives you the day number of the year, other
than dd which would only work for the month of January. We don't even
have a built in or Analysis ToolPak function. You could use the UDF to
get the day in the year:
Function DAYINYEAR(DateForNumber As Date) As Integer
DAYINYEAR = DateForNumber - DateSerial(Year(DateForNumber), 1, 0)
End Function
Maybe one of the other spreadsheet programs has it as a format or
function.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.