hi
I have read the various discussions on countif and can't find the correct
solution to my question.

My spreadsheet contains dates in column B. I want to show a summary in a
single cell for each year, firstly the year (2004) and secondly the number of
individual dates for that year (16)

I have used ="2004"&" "&countif(b1:b105,"<383532) this works fine for
the 1st year.

For the second year the formula needs to show from and to numbers,
representing the first and last dates in the year.

I have tried a countif -countif fomula, but this shows an incorrect numer

Any help would be greatly appreciated

Thanks Joco in London