After some help please - at my wits end now! I am using Excel 2007 and am
trying to count cells which meet a certain criteria. Originally had no
problems with this. Colum G contains 'subjects' and E contains a date entry
formatted dd.mm.yy

=COUNTIFS('On Call'!G:G,"Math*",'On Call'!E:E,"*.09.09")

Had trouble sorting in date order with this format as it is not a 'date' as
such.

The date is now being entered dd/mm/yyyy and is formatted as a date but alas
my formula now returns zeros throughout

=COUNTIFS('On Call'!G:G,"Math*",'On Call'!E:E,"*/09/2009")

I've tried removing the the wildcards and replacing with whole date but that
makes no difference. i've tried numerous different counts, sumifs,
sumproduct to no avail. this one does produce a result but not the correct
one!

=COUNTIFS('On Call'!$G$2:$G$220,"=English",'On
Call'!$E$2:$E$220,"<="&DATE(2009,11,31))

Any help would be gratefully received