Hi,

The key to solving this problem is to know what you actually have in B10:

(10/1/2008 - 10/31/2008)
or
10/1/2008 - 10/31/2008

Before we get carries away, I notice that this represents October. You can
make your task easier if you enter October or Oct in cell B10 if you are
trying to indicate a whole month. Or better yet enter 10/1/2008 and format
it to show Oct-2008.

In this last case the formula would be

=if(AND(A5C5,MONTH(A10)=MONTH(B10)),"Yes","No")

--
Thanks,
Shane Devenshire


"Yossy" wrote:

If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks