# IF/EXACT/Dates Help

#### The_Game

##### New Member
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.

 Excellent R/A/P/S 11-Apr-15 31-Apr-16 Satisfactory R/A/P/S 11-Apr-15 31-Oct-15 Satisfactory R/A/P/x 11-Apr-15 31-Oct-15 Excellent R/A/P/x 11-Apr-15 31-Oct-15 Excellent R/A/P/S [/TD] [TD][/TD] [/TR] [/TABLE]

<TBODY>

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Maybe:

Book1
ABCD
1ExcellentR/A/P/S11-abr-1530-abr-16
2SatisfactoryR/A/P/S11-abr-1531-out-15
3SatisfactoryR/A/P/x11-abr-1531-out-15
4ExcellentR/A/P/x11-abr-1531-out-15
5
6ExcellentR/A/P/S
Sheet5
Cell Formulas
RangeFormula
D1=IF(AND(EXACT(A1,\$A\$6),EXACT(B1,\$B\$6)),EOMONTH(C1,12),EOMONTH(C1,6))

and drag down...

Last edited:
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?

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

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!

Replies
4
Views
457
Replies
0
Views
267
Replies
1
Views
458
Replies
1
Views
776
Replies
2
Views
233

1,203,240
Messages
6,054,319
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back