Excel - Count years

[Bill4tektips]

Can anyone give me the formula for counting Years in Excel 2007?
I have a spreadsheet with thousands of entries over the last 10 years and I need to count how many there are per year.

 

[SkipVought]

I need to count how many there are per year.

Use a PivotTable and the GROUP feature in the PT will allow for YEAR.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}