Excel IF with DATEDIF, when Date is blank

Assistance with this formula. If the date cell is blank, leave blank, otherwise if the date is less than today, give the difference in months:

=IF(F5="","",(F5<TODAY(),DATEDIF(F5,TODAY(),"M")))

1 Answer

There is a tiny mistake there.

=IF(F5="","",IF(F5<TODAY(),DATEDIF(F5,TODAY(),"M")))

Tell me to know if it works for you