Remove or highlight row with date only within one year

[soicy23]

I am an excel novice so I am hoping my question makes sense. I need to have the dates highlighted if it falls within 1 year by the last date entered. If a date falls out of the 1 year range, for it to not have the highlight.

for example.

7/2/2015
11/2/2015
3/1/2016
4/29/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017

[chullan88]

I am an excel novice so I am hoping my question makes sense. I need to have the dates highlighted if it falls within 1 year by the last date entered. If a date falls out of the 1 year range, for it to not have the highlight.

for example.

7/2/2015
11/2/2015
3/1/2016
4/29/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017

Hi soicy123,

I really didn't get your question but I hope the answer benefits you.

The last date in the range is 4/1/2017 ; so the date 1 year before is 5/1/2016

There are three dates in the range coming before this date ; this formula will not highlights these three dates.

Use the formula in CF :

Please Login or Register  to view this content.

where $A$2:$A$17 is the range of the dates.

See attached file.