Ok, I have two columns
first one (H3:H17) representing the date in which fees were paid for a
tennis club and the second (K3:K17) representing when the fees are due
(1/9/06)

The 3 members who didn't pay their fees on or before the due date
aren't considered 'current' members,

I need to construct a formula which counts all the 'current' members.

I beleive it would need to be a count formula using a date and
counting if the date occurs prior to or on the due date.

plz help,

1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/14/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/17/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/9/06 1/9/06
1/10/06 1/9/06


--
Drummy
------------------------------------------------------------------------
Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780
View this thread: http://www.excelforum.com/showthread...hreadid=548468