How do I skip the "IF" formula to count items that are late vs on time when finish date is blank?

Shawn_Morin 

To modify your IF formula to return a blank cell when the "Actual Finish" date is missing, you can add an additional condition to check if the "Actual Finish" date cell is blank. Here's how you can adjust your formula:

=IF(C2="", "", IF(C2<=B2, "on time", "late"))

In this modified formula:

• The first IF function checks if the "Actual Finish" date in cell C2 is blank. If it is, it returns a blank cell ("").
• If the "Actual Finish" date is not blank, the formula proceeds to the nested IF function.
• The nested IF function then checks if the "Actual Finish" date (C2) is less than or equal to the "Planned Finish" date (B2). If it is, it returns "on time". Otherwise, it returns "late".

With this modification, if the "Actual Finish" date is blank, the formula will return a blank cell instead of evaluating whether it's on time or late. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.