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

[Michael_Day]

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

[Mohamed_Swella1]

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())

BR,
Mo

[Michael_Day]

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