I can Google just fine. Most of the time was spent trying to find the correct conversion formula for Excel*, and coming across lots of people who didn't know the difference between Julian days and Julian dates. Then I found this:The Fex wrote:Yup. I was starting to think I might have to wait 639 years for you lot to learn to Google.Blank_Frank wrote:ASLSP
After which I gave up for a while...Which Julian format..?
Julian Date (JD)
Julian Day Number (JDN)
Chronological Julian Day (CJD)
Reduced Julian Day (RJD)
Modified Julian Day (MJD)
Truncated Julian Day (TJD)
Dublin Julian Day (DJD)
Once I'd got the list of dates I used My Brain(TM) to get the answer.
* It's =A1-2415018.5, for anyone who's sad enough to want to know.








