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