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

3

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy