If Function and dates

[mattyblueice]

I have a sheet where I want to flag 60, 90 and 120 days reviews based on an effective date and Calendar dates, but the formula I have is not working. Here is what I have:

[TABLE="width: 900"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Customer[/TD]
[TD]Effective Date[/TD]
[TD]11/1/2017[/TD]
[TD]12/1/2017[/TD]
[TD]1/1/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]B. Smith[/TD]
[TD]9/1/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here is the formula I have in D2 and copied over to E2:F2

=IF(($C2+60)=11/1/17,"60 Day Review",IF(($C2+90)=11/1/17,"90 Day Review",IF(($C2+120)="11/1/17","120 Day Review","")))

D2 should say 60 Day Review, E2 should say 90 Day review and F2 should say 120 Day Review, but it does not - they are all blank.

Any ideas on how to get this to work?

Thanks!

Matt

 

[mattyblueice]

I want it to show nothing if its a 30 day review. I will try that now - thanks for all of your help!