Julian Date

%3CLINGO-SUB%20id%3D%22lingo-sub-1932647%22%20slang%3D%22en-US%22%3EJulian%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932647%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20tips%20for%20converting%20a%20date%20to%20Julian%20date%20format%3F%20Can't%20believe%20it's%20not%20one%20of%20the%20options%20in%20formats.%20They%20post%20multiple%20ways%20to%20do%20it%20using%20formulas%20and%20converting%20to%20number%20format%20but%20none%20of%20it%20works.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1932647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1932796%22%20slang%3D%22en-US%22%3ERE%3A%20Julian%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1932796%22%20slang%3D%22en-US%22%3ETo%20get%20the%20day%20of%20the%20year%20(assuming%20date%20in%20A1)%20%3DA1%20-DATE(YEAR(A1)%2C1%2C0)%3C%2FLINGO-BODY%3E
New Contributor

Any tips for converting a date to Julian date format? Can't believe it's not one of the options in formats. They post multiple ways to do it using formulas and converting to number format but none of it works. Thanks!

2 Replies

To get the day of the year (assuming date in A1) 

 

=A1-DATE(YEAR(A1),1,0)