Dates: How many entries per week?

[Guest]

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 date>a1
and <a2.
Is there an easy way to do this?

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

thanks

 

[Guest]

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

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

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

 

[Guest]

This is not working for me. I get an error message about Logical1 that points
to a1. Should A1 not be a date? I have it as the 8/7/05 of the first date to
check against.

Thanks

 

[Guest]

OK, try this one that is simpler:

=SUM((A5:A50>A1)*(A5:A50<A2))

Don't forget the CTRL+SHIFT+ENTER

 

[Guest]

Rogerio, no error message now, but an answer of 0 which is clearly not true.
Thanks, Jill

 

[Guest]

Can you send me a copy of your worksheet at (e-mail address removed) ?

 

[Guest]

Rogerio - thanks for your help with this. Your 3/3 solution worked, once I
had corrected my invalid dates.
Jill