This works fine, meaning it applies to the entire column.
=ARRAYFORMULA(IF(J:J > TODAY(), DATEDIF(TODAY(),J:J,"D"), "x"))
But I want to exclude the first J row which is not a date, I need to add AND so it becomes
=ARRAYFORMULA(IF(AND(ISDATE(J:J), J:J > TODAY()), DATEDIF(TODAY(),J:J,"D"), "x"))
and now it doesn't work anymore and the entire column is empty
So how to make ARRAYFORMULA work with multiple conditions ?
Aucun commentaire:
Enregistrer un commentaire