I have three cells that may or may not have dates in them (all three could
have dates, two could have dates or all three could have no dates:
1) Actual Completion Date
2) Revised Completion Date
3) Estimated Completion Date
I need multiple comparisons made among the three dates all done in one cell.
If actual completion is blank, return "" and stop. If revised completion
date is blank, compare to see if actual completion date is estimated
completion date; if so, return "fix date", otherwise return actual completion
date and stop; if revised completion date is not blank, compare to see if
actual completion date is revised completion date; if so, return "change
date"; otherwise return actual completion date.

I have tried numerous formulas but am stumped on the complexity. Any help
would be greatly appreciated. If you need more information to assist me,
please let me know. Thanks.

KK

Hi,

Try this. A2 has actual completion date, B2 has revised and C2 has
estimated completion date.

=IF(A2="","",IF(B2="",IF(A2C2,"Fix date",A2),IF(A2B2,"Change date",A2)))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KalliKay" wrote in message
...
I have three cells that may or may not have dates in them (all three could
have dates, two could have dates or all three could have no dates:
1) Actual Completion Date
2) Revised Completion Date
3) Estimated Completion Date
I need multiple comparisons made among the three dates all done in one
cell.
If actual completion is blank, return "" and stop. If revised completion
date is blank, compare to see if actual completion date is estimated
completion date; if so, return "fix date", otherwise return actual
completion
date and stop; if revised completion date is not blank, compare to see if
actual completion date is revised completion date; if so, return "change
date"; otherwise return actual completion date.

I have tried numerous formulas but am stumped on the complexity. Any help
would be greatly appreciated. If you need more information to assist me,
please let me know. Thanks.

KK