Conditional Formatting for cells within 1 year from todays date

[RJB78]

Hello. Does anyone have a formula for conditional formatting to change the color of cells if the date in the cell falls within the past year.

for example: I would want 11/16/16 to be a color, and 11/16/15 to not have a fill color.

Thank you in advance.

 

[Joe4]

This formula will check to see if the date in A1 is after the date exactly one year prior to today:

[COLOR=#333333]=A1>[/COLOR]EDATE(TODAY(),-12)

So, use that as your CF formula.

If you want to exclude future dates, just change it to:

[COLOR=#333333]=AND(A1>[/COLOR]EDATE(TODAY(),-12),A1<=TODAY())

 

[RJB78]

Thank you very much

 

[Joe4]

You are welcome!