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