# Notion Answers

Help between Notion users

It's free & easy

### Get answers

Answers, votes & comments

### Vote and select answers

Receive points, vote and give the solution

4votes

# Show every three years date and it is today with Notion formulas

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.

1vote

### chibuzorobilom commented Mar 5, 2021

trying this out, now...

## 1 Answer

2votes

NotionNoah Points180

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

0vote

### nosy commented Feb 11, 2021

Thanks! But the link is private and I can't see it.

0vote

### NotionNoah commented Feb 11, 2021

Oops, sorry. I made it public now, so it should work. https://www.notion.so/Check-if-same-day-58aaa9bcb2d64553b6bcf6f4c2397d9e

0vote

### nosy commented Feb 14, 2021

It is not working, I need to add a date and a formula that shows that date every 3 years and then a true if it is today.

I add in "date" column jan 24 2019, the "next" column shows when is the next day 3 years later and it is jan 24 2022 and column "today" shows as true if today is what "next" date shows.

After jan 24 2022, the "next" column should show jan 24 2025 and so on.

Thank you.

1vote

### NotionNoah commented Feb 14, 2021

I'm sorry, but I don't understand the problem then. Hope someone else can help you!

0vote

### nosy commented Feb 17, 2021

Thank you, hopefully someone else can share a way to do it.

## Please log in or register to answer this question.

### Latest Comments

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!