Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiplying Dates by Months using If Statement

Topic Labels: Formulas
386 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

Hi Lisa,

Did you ever figure out a solution to this issue?