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
However you may be better served by creating a LUT needing to accommodate for leap years