Date Calculation in Conditional Formatting

[JPS]

I have a column of dates and if a date is 6 month or less in the future of
the current month TODAY(), I need to have the cell red. I know this can be
accomplished through conditional formatting but need some guidance on the
formula.

Thanks

 

[Mike H]

Hi,

Select your data and then
Format|Conditional format
formula is

=$A1>=DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))

Pick a colour
OK

Mike