Question

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?

Thanks.

Comments

trying this out, now...

Answer 1

If I understand your question correctly, here is the solution:

https://www.notion.so/Check-if-same-day-58aaa9bcb2d64553b6bcf6f4c2397d9e

1. Make a column with the date you want to check
2. Make a formula that calculates the date 3 years from now

   dateAdd(prop("Date"), 3, "years")

3. Check if it falls on the same day

   day(prop("Date")) == day(prop("3 yr"))

4. Duplicate the rows and slightly change formulas for 6 years, 9 years, etc.
5. ???
6. Profit