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