IF formula with differents dates

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


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},

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


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