Date Calculation in Conditional Formatting
 

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

Date Calculation in Conditional Formatting
 

Hi,

Select your data and then
Format|Conditional format
formula is

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

Pick a colour
OK

Mike

"JPS" wrote:

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

Date Calculation in Conditional Formatting
 

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