Greg,

Thanks that worked.

Now I have another issue. The spread sheet I have created is basically an
action plan (column A Date Opened, column B Issue, column C Root Cause,
column D Action Plan, column E Responsible, column F Date Due, column G Date
Complete, column H Status R/Y/G) is my issue, the date due column could be
out as far as 30 + days (i.e. date open is 5/25/05, date due could be
6/25/05) when I put in the 6/25 date column H says it is false, when infact
it should be Green. What can I do to correct either the cell formula or the
formula in CF or both?

Thanks for your help,
Roy

"greg7468" wrote:


Hi Roy,

=IF(F2<=TODAY(),"RED",IF(F2<=TODAY()+5,"YELLOW",IF (F2<=TODAY()+25,"GREEN")))

HTH.

Greg.


--
greg7468
------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=373867