Nov 25 2020 03:38 PM
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!
Nov 25 2020 05:48 PM - edited Nov 25 2020 05:50 PM
To get the day of the year (assuming date in A1)
=A1-DATE(YEAR(A1),1,0)