If your dates are in cells A5:A50, you can try this matrix formula:

=SUM(IF(AND(A5:A50A1;A5:A50<A2);1;0))

Remember that matrix formulas MUST be finished with a CTRL+SHIFT+ENTER

--
Rogerio Takejame
Americana - Sao Paulo - Brazil


"Jill" wrote:

I have a spreadsheet with entries by date. I would like to know how many
entries per week there are. I have created a list of beginning dates for
weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1
and <a2.
Is there an easy way to do this?

Alternative is there a way to count how many entries per month?

thanks