Hi!

Try this:

Real dates are just numbers formatted to look like dates.

9/20/2005 is really the numeric value 38615 formatted to look like 9/20/2005

Make sure CREDIT!$A4 is a real date.

=ISNUMBER(CREDIT!$A4) should return TRUE

Try to find corresponding cells in your range that match each criteria:

Y200 = 26
AJ200 = CREDIT!$A4

=ISNUMBER(Y200) should return TRUE
=ISNUMBER(AJ200) should return TRUE

Assume AJ200 "matches" the date entered in CREDIT!$A4

=AJ200=CREDIT!$A4 should return TRUE

Biff

"vect98" wrote in
message ...

hey thanks for your help, i converted both columns to numbers but it
still doesnt work , just comes up with 0 which it shouldnt. the 26 is
one condition the other condition is a date, so maybe that is affecting
it??


--
vect98
------------------------------------------------------------------------
vect98's Profile:
http://www.excelforum.com/member.php...o&userid=26365
View this thread: http://www.excelforum.com/showthread...hreadid=469366