Hi

With dates in column A, start / end date in B1:B2 try this formula:

=SUMPRODUCT(--(A1:A100=B1);--(A1:A100<=B2))

Regards,
Per

"tartanspice" skrev i meddelelsen
...
I am a relatively unskilled user of Excel at the moment. I have a column of
dates where I would like to count the number of occurrences within a week
i.e. between 2 dates. Say I have a set of dates spread over 1 month; I
want
to end up with 4 separate figures for each week of that month. Is this
possible in one formula? So far I have resorted to sorting the column in
date order and created separate Sum fields for each of the 4 weeks but
this
seems unweilding and I have to do the same thing on multiple sheets within
a
workbook.