IF formula with differents dates

[alexandre_Roy]

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

[Mohamed_Swella1]

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