A formula solution where your date to compare is in cell o1

=IF(AND(O2="yes",P2$O$1,Q2$O$1),"go","no go")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bernie" wrote in message
...
I'm dealing with only 4 specific columuns in a worksheet. If the cell in
one
column is YES (O4) and the two other columns have dates greater than 5 Jul
08, then I want to show "GO" in the fourth column otherwise it would
reflect
"NO GO". I should know this but haven't worked with Excel for about a
year
and forgotten too much.

Appreciate any assistance.