# Calculate Current Day of Year

**URL:** <https://community.glideapps.com/t/calculate-current-day-of-year/85401>\
**Category:** Ask for Help\
**Created:** [November 15, 2025, 8:37pm UTC](https://community.glideapps.com/t/calculate-current-day-of-year/85401 "2025-11-15T20:37:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gannonatwork](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gannonatwork/32/91717_2.png) [@gannonatwork](https://community.glideapps.com/u/gannonatwork)\
**Post date:** [November 15, 2025, 8:37pm UTC](https://community.glideapps.com/t/calculate-current-day-of-year/85401/1 "2025-11-15T20:37:26Z")

</div>

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.

 ![Screenshot 2025-11-15 at 12.30.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9bf64bf02f233a18d961d6b5df5d4e1e4f98084e.jpeg)

 ![Screenshot 2025-11-15 at 12.51.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0cf688061c6f8a0c4c0f3dab191c8f1e3a0a98d.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 15, 2025, 9:04pm UTC](https://community.glideapps.com/t/calculate-current-day-of-year/85401/2 "2025-11-15T21:04:59Z")

</div>

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

> [@date Guide on Dates & Times](https://community.glideapps.com/t/guide-on-dates-times/70381/1):
>
> Get Ordinal day (day of the year)
> 
> This will return a day number (1-366) for a given date.
> 
> ```auto
> 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))
> 
> ```

---

<div class="post-metadata">

**Author:** ![gannonatwork](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gannonatwork/32/91717_2.png) [@gannonatwork](https://community.glideapps.com/u/gannonatwork)\
**Post date:** [November 16, 2025, 12:18am UTC](https://community.glideapps.com/t/calculate-current-day-of-year/85401/3 "2025-11-16T00:18:05Z")

</div>

@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`

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 23, 2025, 12:18am UTC](https://community.glideapps.com/t/calculate-current-day-of-year/85401/4 "2025-11-23T00:18:43Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.