, Good morning.
Please give us more information about your logic.
As you say any of the three cells can contain the IF clause, what happens if A2 <01/01/2000 and C2 is between 01/01/2000 and 12/31/2012 and E2> 12/31/2012?
What will be the response group?
We need to know how your layout is to help you faster and more conclusively.