Conditional Form between date range..

[BenGee]

I already have formats for;
<6months
=F9>=TODAY()-180)

>2years
=F9<=TODAY()-730

However, I can't seem to format 7 months - 23 months.. What I've tried using is;
=AND(F9>=TODAY()-213,F9<=TODAY()-700)

Any idea's?

Thanks

 

[MARZIOTULLIO]

Hi


=AND(F9<=EDATE(TODAY(),-7),F9>=EDATE(TODAY(),-23))

 

[BenGee]

Thanks for replying MARZIO

I've tried using your formula, but the cells still wont format 'orange' as I want them to.

With the conditional formatting, the should end up looking like;

21/09/2015 (Orange)
18/01/2016 (Red)
26/04/2010 (Green)
11/07/2011 (Green)
07/04/2014 (Green)
23/05/2011 (Green)
27/07/2015 (Orange)
03/06/2013 (Green)
27/07/2015 (Orange)
25/01/2016 (Red)

Even with your formula, the 'orange' dates aren't formatting to orange (whereas the others are turning green / red)