CF/ Formula IS:
=DATEDIF(TODAY(),A1-1,"m")<6
--
David Biddulph

"JPS" wrote in message
...
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
--
JPS