# 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:** 1\
**Showing post:** 2

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

---

_[View the full topic](https://community.glideapps.com/t/calculate-current-day-of-year/85401)._