Find the Next Anniversary date from start date

I’m trying to setup a formula that will find the next anniversary date. Then I will setup a automation 5 days before that date to create item in our weekly update board so celebrate with the team.

Hi Blaine,


IF(DATE(YEAR(NOW()),MONTH({Start Date}),DAY({Start Date}))>NOW(),FORMAT_DATE(DATE(YEAR(NOW()),MONTH({Start Date}),DAY({Start Date}),"MMM D, YYYY")),FORMAT_DATE(DATE(SUM(YEAR(NOW()),1),MONTH({Start Date}),DAY({Start Date})),"MMMM D, YYYY"))

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

This worked! The sorting is off it doesn’t look like it is shorting by date but instead the first letter of month. Do you know if I can change that?

Change "“MMM D, YYYY” for “YYYY-MM-DD” (twice in the syntax).