Formula with Dates and Blank Fields

SmeyerEnpointe

I have this formula that shows if a project is completed on time or if it is late. But there are occasions the the Proof Due Date will be blank. How would I modify this formula to say No Proof Date, if the field Proof Due Date is blank?

=IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time")

Kelly Moore

Hey @SmeyerEnpointe

=IF(ISDATE([Proof Due Date]@row, IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time"),"No Proof Date")

Does this work for you?

Kelly

SmeyerEnpointe

I get an error incorrect argument

Kelly Moore

oops. I typed too fast. I forgot the closing parenthesis of the ISDATE

=IF(ISDATE([Proof Due Date]@row), IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time"), "No Proof Date")

SmeyerEnpointe

Works perfectly, thank you