how to conditionally format cell if the date it contains is within next 6 months.

[Jason_C]

Using excel 2010, how can I conditionally format a field that has a date within 6 months from today? I can use the template formats for unto one month, but how do i have this option for 6 months?

[arthurbr]

Supposing your date is in B1 enter following formula in the CF

Please Login or Register  to view this content.

and format as needed

[Cutter]

An alternative:

=B1<EDATE(TODAY(),6)