In a Notion table with a date I need to calculate every three years, show the next date and mark it as true if it's today.
I have 3 columns in my Notion database table:
1- Date: Jan 23 2021
2- Next (Formula): Use the date and show (based on 3 years) when is the next date. This Next column should show "Jan 23 2024" and do that continuously, so after Jan 23 2024, "Next Column" will display "Jan 23 2027" and so on.
3- Today (Formula): If "Next Column" is today, checkbox true.
If I select today as a date I can make it work, the problem comes when I add a past date, like "Oct 23 2018".
Can anyone please share how to create the Notion formulas for 1 and 2?