# Calculating next anniversary in Glide **URL:** \ **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:** 3\ **Page:** 1
**Author:** ![Dolapo\_Amusan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dolapo_amusan/32/16764_2.png) [@Dolapo\_Amusan](https://community.glideapps.com/u/Dolapo_Amusan)\ **Post date:** [August 25, 2021, 9:07am UTC](https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917/1 "2021-08-25T09:07:51Z")
Hi everyone, Is there a way to calculate the next birthday or anniversary of a particular date in Glide? Meaning if the date is 25/03/2021, the next anniversary will be calculated as 25/03/2022. And if the date is 27/08/2020, the next anniversary will be calculated as 27/08/2021. (for context, today’s date is 25th August 2021) ---
**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")
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 … ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [August 25, 2021, 11:40am UTC](https://community.glideapps.com/t/calculating-next-anniversary-in-glide/30917/3 "2021-08-25T11:40:20Z")
is quite simple… the only problem is with leap years… February 29 will be hard to do… any other date just substitute the year from the date with the current year… in a template column