What do you have in AMS!$B$4:$B$60000, are they dates? If so try
(TEXT(AMS!$B$4:$B$60000,"yyyymmdd")=Summary!C3)
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=524394