Still applies, different values, but I thought you could have figured that

=IF(NOT(ISNA(MATCH(A2,M1:M100,0))),12.5,0)

where A2 is the date in one table, M1:m100 is the other table of dates.

Adjust to suit.



--

HTH

RP
(remove nothere from the email address if mailing direct)


"PaulOakley" wrote
in message ...

Hey,

Thanks for your relpies, they are really appreciated, my first message
is a bit unclear.

I need one table which has w\commencing dates in it to check these
dates with another table, if the w\c date is matched with a date in the
other table then i need it to return the value 12.5, if it is not then
the value 0 needs to be returned.

Some background which may help is that the system i am building is
taking into account the second sunday of every month, where 12.5 hours
of cleaning is required (this will be placed in a cell and then
deducted from the total hours of operations). I have built a seperate
table in another sheet with the w\c date of the second sunday of every
month. My problem is that many of the week commencing dates that I am
checking are not present in the new sheet.

I hope this helps clarify my problem a bit more,

Thankyou in advance.


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=386726