CALCULATED column issue

Question

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

Answer 1

Try using this formula:

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

OR

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

Documentation: Calculate the difference between two dates