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
2
