Excel If with Datedif, When Date Is Blank

Robert Thorne
Robert Thorne
• • 1 min read

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

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

Must Read

Your Answer

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

Robert Thorne

Robert Thorne

Automotive & Future Transportation Editor
Twitter Linkedin

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.

Share this article
Twitter Facebook Pinterest