Trying to narrow down some data

[HeRoseInThree]

I have a range of dates in column A and I only need to identify the dates within the last 2 years. Is there a way to use conditional formatting to only highlight the dates that are within the last 2 years?

Thanks in advance!

 

[Joe4]

For a value in cell A1, use a Conditional Formatting formula like this:

=AND(A1>0,A1>EDATE(TODAY(),-24))

If you may have future dates that you want to exclude, add one more condition:

=AND(A1>0,A1>EDATE(TODAY(),-24),A1<=TODAY())

 

[HeRoseInThree]

I have no idea how you do that, but you did!!!!!

THANKS!!!!

 

[Joe4]

You are most welcome!

The key is the EDATE function, which is explained in detail here: https://www.techonthenet.com/excel/formulas/edate.php
Basically, we are just looking for data that are after 24 months prior to the current date.
The other checks are just to make sure that the cell isn't empty, and the date is prior to today.
By putting all the conditions in an AND function, it will only return True if all conditions listed are True.