Scenario: Need to get difference between two dates (Start Date, End Date) in months, and if End Date is blank, then display "Open".

I am trying:

=IF(AND(ISBLANK[End Date], " ", (DATEDIF([End Date], [Start Date], “M”)))

1 Answer 1


Try using this formula:

=IF(ISBLANK([End Date]), "Open", DATEDIF([End Date], [Start Date], "M"))


=IF(ISBLANK([End Date]), "Open", Text(DATEDIF([End Date], [Start Date], "M")))

Documentation: Calculate the difference between two dates

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.