Hi.

I am working on moving our workflow from google sheets to Airtable.

We have clients who have contracts for 12, 18, 24 or 36 months.

We are trying to have a column where we see their anniversary.

I figured out the 12 month, that was easy because everyone is at least 12 months.

It get’s tricky with formatting after 12 months.

What I want to tell it to do is check if the term is greater than 18. If so, then calculate what the 2 year anniversary is (because not everyone has a 2 year anniversary, or a 3 year anniversary)

I tried this and it didn’t work:

IF( Term]>18, DATEADD({First Month}, 24, ‘months’),"-").

Help!