I have a marriage date for some people and no date for others. I created a field called THIS YEARS ANNIVERSARY as shown below.
‘MMM D YYYY’
I need a formula for NEXT year’s anniversary. If THIS YEARS ANNIVERSARY was a simple date field, I know how to use the DATE_Add formula but I am struggling with how to use the DATE Add formula to this formula field so it is also seen as a date so I can use it as a date field in a calendar.
Any help would be appreciated.
Solved! Go to Solution.
I have to echo @Justin_Barrett’s comment here. I like the option to set it up where it adjusts to the next year once the anniversary has passed. I did something something very similar for birthdays and it worked great! It was pretty much a birthday countdown calendar for people I worked with.