Thanks for both your replies and yourkind offer Satyendra but I think I may
go with Rosa's idea with one extra question please - when I do that Rosa the
dates split at each day ie" all listed for 16th Sep etc - I want to actually
have it split at the end of each year only what would you suggest I change??
--
Thanks

Lise


"Rosa59" wrote:

You can use the Data-Subtotals feature. Select the table and headers and
choose "at each change in YEAR" to Count the rows and put the subtotal below
the data.

"Lise" wrote:

I have a spreadsheet with 2318 rows dates ranging from 2003 through to 2008 -
I would like to have the sheet split at the end of each year and count how
many rows are in each section - can this be done please
--
Thanks

Lise