List month from any given year in excel

Hello,
i 0got a spreadsheet (data) as below
date status
1-jan-1975 approved
1-feb-1980 suspended
5-mar-1985 rejected
10-oct-1985 suspended
29-Oct-2004 approved

got a report sheet where the summary is listed as below
count for the year - (year)
month approved suspended rejected


based on the year the user types in the (year cell)...e.g. 2009 the months should be generated below the month column and below each status e.g. approved it should get the total count of approved status for the month of january 2009 from the data sheet and count for suspended for the month of jan . likewise count for all months according to their status.

i cud do the above by a macro...but like to use functiions if possible for this.

any help wil b much appreciated.
thanks