This Question is Answered 

    I Need To Create A Timeline With Mixed Julian And Gregorian Dates That I Would Like To Line Up Correctly. Does Anything Exist That Can Do That?

    I need to create a timeline for events during the Jacobite rebellion of 1745/6 where those that occurred in Europe have dates that are in NS and those in Britain are in OS.

    asked 4 months ago

    Date | Rating

    Answers


    Julian date is Easy in Excel:
     
    With the date in cell 'A1' The formula for julian date is:
    =RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000")
     

    answered 4 months ago

    New Comment

    1000 words left