Find the Next Anniversary date from start date

Platform discussions Special workflows & use cases
1

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.

image
image766×334 27.8 KB

2

Hi Blaine,

Try:

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.

4

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?

image
image737×369 35.9 KB

5

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