Conditional Formatting for Calendar Months

[psunder]

With conditional formatting, how do I flag a value in terms of calendar months? ie. I want to flag any cell with a date over 6 calendar months old: 01/17/2017 would flag on 07/31/2017, 08/03/2017 would flag on 02/28/2018. Thanks!

 

[SpillerBD]

for the "is less than Value" use

=EDATE(TODAY(),-6)

or similar calculation.

 

[psunder]

Thanks for the response. The above formula appears to reference a date 6 months prior, I am needing 6 calendar months prior.

Examples would be: 01/17/2017 would flag on 07/31/2017, 08/03/2017 would flag on 02/28/2018.

Thanks!

 

[Tetra201]

If you still need this, try

=AND(ISNUMBER(A1),TODAY()>=EOMONTH(A1,6))