Use a pivot table and group the dates for months

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://www.contextures.com/xlPivot07.html

--

Regards,

Peo Sjoblom






"Brie" wrote in message
...
Hi all,

I have a table like this

Name submit date
A 10-Jan-2006
B 13-Jan-2006
C 25-Feb-2006
A 5-Jul-2007
D 18-Aug-2007
C 23- Oct-2007

Questions:
1. how to count the total entries of each month per year and total entries
per year, ignoring the first column; so I will have Jan-2006=2 entries,
Feb-2006=1 entries; also 2006=3 entries, etc.
2. how to count and relate the two column; so I will have A on Jan-2006
submitted 2 entries etc.

Thank you so much for your help.

Brie