Calculate Current Day of Year

[gannonatwork]

I’m using the FLOOR function() to calculate the current day of the year, see below. I could understand why the formula might require a +1 to calculate the correct number (which today on November 15 is 319), but as it currently stands the formula requires a +2 to be accurate. Am I missing something or is there a better way to do this? Thx!

P.S. For context, to dynamically generate the “Year Start Date” column I’m using a Math column to calculate the current year, then a Template column to format to “2025-01-01”, and finally a Text to Date column to generate a date-specific value.

[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))

[gannonatwork]

@Jeff_Hager I appreciate you taking time to send over the link to this date calc guide — super helpful! I was waiting to respond until after UTC+0 hit midnight about 15 min ago. Since Glide uses UTC+0 as it’s default time zone, the formula works perfectly (using just a single column) by just adding +0.5 to the very end, see below. Big “thanks” to @nathanaelb as well for compiling all of this date/time info into a single post. Much appreciated!

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))+0.5