I want to count occurences between 2 dates.
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.
|