Add days to date depending on selection from a single-select column

Topic Labels: Formulas
1022 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All,

Was hoping to get some input on the formula below:

IF({D-Phase Status} = “D1 - Concept”, DATEADD(TODAY(), 30, ‘days’), TODAY())

I am trying to put together a formula which will add 30 days to today’s date if D1- Concept is chosen in the single select menu of the D-Phase Status column otherwise, just to display today’s date. I can’t quite work out why the formula isn’t working and would really appreciate your help.

Thanks in advance

2 Replies 2

Hi @Michael_Day,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

The formula works fine for me, im assuming you are not using the curly quotation and using the straight ones?

IF({D-Phase Status} = "D1 - Concept", DATEADD(TODAY(), 30, 'days'), TODAY())


4 - Data Explorer
4 - Data Explorer

Hi @Mohamed_Swellam

I was using the curly brackets - those were the ones that Airtable adds automatically if you click the name of a column from the formula menu when typing it out.

However, I literally just re-entered the formula and now it works - zero changes!? So confusing