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