I have two cells with completed installation dates. I have a 3rd cell where I need to input outstanding installations.

If the 2 cells have dates, it means the installation is complete so I want the 3rd cell to show 1 or 2 to show 1 or 2 completed installs.

How do I do this in excel?


  • If your first two cells are A1 and A2 then you could e.g. use =COUNT(A1:A2) & " installs completed.". Is it what you need? – Máté Juhász May 16 '18 at 11:43
  • Thinking ahead, will there be cases of more than two installs? – CharlieRB May 16 '18 at 11:52

Like @Máté mentioned, it depends on what exactly you want to see.

If you need to see the specific details summarized, you can use a combination of IF() and AND() statements, like:

=IF(AND(A2<>"",B2<>""), "#1 & #2 Completed",IF(A2<>"","#1 Completed", IF(B2<>"", "#2 Completed", "None Completed")))

If you just wanted to see an overall count of progress, you can use what @Máté mentioned in the comments (COUNT works because dates are stored as numbers):

=COUNT(A2:B2) & " installs completed."

I'm assuming you Dates are in A2 & B2.

| improve this answer | |
  • 1
    You're absolutely right, sorry about that. I updated the formula to say "None Completed" in that case. – mlhDev May 16 '18 at 11:55

Your Answer

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

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