=COUNTIF('mail-data'!D2:D1000, "12/01/2005and<01/01/2006")

I've been trying to count a cell range that contains data on another
sheet 'mail-data', where the date is bigger than 1 december 2005 and
smaller than 1 january 2006. I keep getting error messages.

help would be appreciated.
Thanks
ArchivesGirl


--
archivesgirl
------------------------------------------------------------------------
archivesgirl's Profile: http://www.excelforum.com/member.php...o&userid=31827
View this thread: http://www.excelforum.com/showthread...hreadid=515511