×
Sign up

Tech Tip: Julian Date Conversion, Excel Formulas

May 21, 2019

 

Excel date formulas:

Julian to Gregorian: =DATE(1900+(A1/1000),1,1)+VALUE(RIGHT(TEXT(A1,"0"),3))-1
Gregorian to Julian: =(YEAR(A1)-2000+100)*1000+A1-DATE(YEAR(A1),"01","01")+1