Hi,

Assume that your data is in range C5:D9 (including the header row). Suppose
in C5:D5, you have Date and Last Name. In C11:E11, type Date, Date and last
Name. In C12, type =1/1/2009 and in D12, type <=31/3/2009. In E12, type
=DCOUNTA($C$5:$D$9,E11,C11:D12)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Carla" wrote in message
...
I have an excel 2007 spreadsheet. It contains a column called lastname
and a column called Class Dates. I want to count the lastnames for a
particular class period. For example count the lastnames for the class
date
Oct.19th-Nov.12th

I tried counif but it keeps returning a zero. The dates are text they are
not formatted as dates.

If possible I would like to have the user prompted for a date range with a
message box and then have it count the last names that meet that criteria.

Any help is greatly appreciated

Thanks