Calculate Current Day of Year

[Jeff_Hager]

Try this. You don’t need all of the extra columns.

@nathanaelb

Get Ordinal day (day of the year)

This will return a day number (1-366) for a given date.

Round(Date-
(((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)-DAY((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)+1))