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

IF formula with differents dates

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

Hello

I’m new in the Airtable community, and formula are definitely not my area of expertise,

I’m trying to make a formula that counts the days of difference between requested return date and the real return dates, however if dates are the same i want the cell to stay empty.

like :
Date return : 02/02/2020
real return : 02/13/2020
Delay : 11

i try with this formula without succes :

IF(IS_AFTER({Real return dates}, {Date return}), DATETIME_DIFF(
{Real return dates}},
{Date return},
‘days’
))

Sorry if this sounds dumb or simple, i’m very new to airtable and formula!

Thanks
alex

1 Reply 1

Hi @alexandre_Roy,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

I think the only problem you had is a formatting problem in your formula. (for example, there is an extra curly bracket after DATETIME_DIFF({Real return dates}}

This one works

IF(IS_AFTER({Real return dates}, {Date return}),DATETIME_DIFF({Real return dates},{Date return}, 'days'))

BR,
Mo