A1 = Original Planned Due Date
B1 = Revised Planned Due Date
C1 = Actual Due Date

Im trying to write a formula that computes the following:

1) If dates exist in cells B1 AND C1, calculate delivery performance (i.e.,
Eary, On-time, or Late) in cell D1

ELSE

2) If dates exist in cells A1 AND C1, calculate delivery performance in cell
D1

ELSE

3) If there are no dates in ((A1 AND B1) OR C1), display €œMissing date(s)€�
in cell D1

The formula I have written so far is:
=IF(AND(CELL("type",B1)="v",CELL("type",C1)="v"),I F(B1C1,"Early",IF(B1=C1,"On-time","Late")),IF(AND(CELL("type",A1)="v",CELL("ty pe",C1)="v"),IF(A1C1,"Early",IF(A1=C1,"On-time","Late"))))

The only part of my formula that Im having trouble figuring out is how to
capture #3 above.

Also, is there a way to rewrite my formula so that it doesnt use so many
nested IF statements? Is there a different Excel built-in function that I
can use to streamline my formula?

Any help would be greatly appreciated.
Thanks,
Bob