IF/EXACT/Dates Help

[The_Game]

I need some help with the formula below in reference to the table. If anything is unclear, I apologize, I'm still new to Excel.

=IF(EXACT($A$5, A1)=EXACT($B$5, B1), EOMONTH((C1), 12), EOMONTH((C1),6))


This is what I'm working with and I'm sure you can tell where I'm going. But incase not, let me explain. I know its an IF formula that I need, so that's where I started. If both A1=A5 & B1=B5 (True), then D1 reports back with a date 12mo out from C1.
But, if either "Excellent" or "R/A/P/S" is false, D1 reports back a date 6mo out from C1. Right now, line 2 is reporting 6mo and line 3 is reporting 12mo. The chart below is correct, but excels not.

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Excellent[/TD]
[TD]R/A/P/S[/TD]
[TD]11-Apr-15[/TD]
[TD]31-Apr-16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Satisfactory[/TD]
[TD]R/A/P/S[/TD]
[TD]11-Apr-15[/TD]
[TD]31-Oct-15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Satisfactory[/TD]
[TD]R/A/P/x[/TD]
[TD]11-Apr-15[/TD]
[TD]31-Oct-15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Excellent[/TD]
[TD]R/A/P/x[/TD]
[TD]11-Apr-15[/TD]
[TD]31-Oct-15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Excellent[/TD]
[TD]R/A/P/S[/TD]
[TD][/TD]
[TD][/TD] [TD][/TD] [/TR] </TBODY>[/TABLE]

 

[Caribeiro77]

Maybe:

Book1
	A	B	C	D
1	Excellent	R/A/P/S	11-abr-15	30-abr-16
2	Satisfactory	R/A/P/S	11-abr-15	31-out-15
3	Satisfactory	R/A/P/x	11-abr-15	31-out-15
4	Excellent	R/A/P/x	11-abr-15	31-out-15
5
6	Excellent	R/A/P/S
Sheet5

Cell Formulas
Range	Formula
D1	=IF(AND(EXACT(A1,$A$6),EXACT(B1,$B$6)),EOMONTH(C1,12),EOMONTH(C1,6))

and drag down...

 

[The_Game]

Alright, that did it! Just curious, is it possible to program x/x/x/x to viod everything and project D1 out to 16 months?

 

[Caribeiro77]

Sorry but i didn't understand what you're asking...

 

[The_Game]

Sorry about that, what I meant was is it possible to input x/x/x/x instead of R/A/P/S and project D1 out to 16 months, rather than 6 or 12? Thank you again for your help; you're a genius!