# Calculating next anniversary in Glide

**URL:** <https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917>\
**Category:** Ask for Help\
**Created:** [August 25, 2021, 9:07am UTC](https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917 "2021-08-25T09:07:51Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 25, 2021, 9:21am UTC](https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917/2 "2021-08-25T09:21:02Z")

</div>

A rough and ready way to do it is with a simple math column that uses the formula `Date + 365.25`  
That’s probably fine for most use cases, but if you need more precision then it’s possible with a slightly more complex math formula. I know that @Jeff_Hager has previously provided a solution for this, I’ll see if I can find it.

Update: I think this is the one I was looking for:

> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15):
>
> Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb …

---

_[View the full topic](https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917)._
