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