I collect data daily from 2005 to Present, when I collect the data I get the Date and the Price. I would create a simple table the 12 months by the year and have to manually type =average(cells) tooo many times. I have been looking online to figure out how I could do this easier, but I can't seem to get a simple answer.

So if I have column A: And Column B has the numbers for that day. Can someone help me figure out a simple IF function or something that would give me the averages for each individual month?

1/2/2009
1/5/2009
1/6/2009
1/7/2009
1/8/2009
1/9/2009
1/12/2009
1/13/2009
1/14/2009
1/15/2009
1/16/2009
1/20/2009
1/21/2009
1/22/2009
1/23/2009
1/26/2009
1/27/2009
1/28/2009
1/29/2009
1/30/2009
2/2/2009
2/3/2009
2/4/2009
2/5/2009
2/6/2009
2/9/2009