I need a forumula that helps me show the number of students enrolled in
a class on any given day.

I have a spreadsheet with two worksheets. One tab has a list of
students and their start and end date in the class, the other tab has a
list of dates in column A.

In column B of the tab with dates, I am looking for a count of how many
students have a start date = AND <= the end date for that particular
day.

I have tried a Conditional Counta, but something is not working. Here
is what I have for a forumla that I am trying to make work. In that
formula A4 is a date in column A. For some reason, the formula returns
9,999 rather than an accurate count.

{=COUNTA(IF(Clients!$C$2:$C$10000=A4,IF(Clients!$ D$2:$D$10000<=A4,Clients!$A$2:$A$10000,0),0))}


--
BradKopecky
------------------------------------------------------------------------
BradKopecky's Profile: http://www.excelforum.com/member.php...o&userid=31479
View this thread: http://www.excelforum.com/showthread...hreadid=511570