I'm working on a survey and one of the fields that they want to autopopulate is the "Julian date" or the "Day of Year". Similar to the week-number function. Has anyone come across anything that I could try?
this formula will create a full Julian date
=TEXT(TODAY(),"yyyy")&TEXT((TODAY() -DATEVALUE("1/1/"&TEXT(TODAY(),"yy"))+1),"000")
However you may be better served by creating a LUT needing to accommodate for leap years
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
