Is there a way to calculate "Day of Year" in Survey123?

05-20-2020 01:03 AM
New Contributor

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?

Tags (2)
0 Kudos
1 Reply
Frequent Contributor III

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

0 Kudos