How to pull values using dates?

[TurkeyFeast]

I have data values for given dates and I want to create a formula that will pull the value from column B based on the date in Column A. However, I would like to have the inconsistently formatted data in Column A be organized by month. Is this possible?

the formula I am using for "avg cars per month" is: =IF(MONTH(A4)&MONTH(A5)=MONTH(C4),AVERAGE(B4:B5),IF(MONTH(A4)=MONTH(C4),B4,"false"))

Date	Cars	Month	Avg Cars per month
1/4/11	50	1/1/2011	50
2/1/11	60	2/1/2011	60
3/1/11	60	3/1/2011	60
3/25/11	42	3/1/2011	42	<- error, should be 51
4/5/11	67	4/1/2011
4/25/11	69
5/18/11	63	5/1/2011
5/20/11	64
6/6/11	66	6/1/2011
7/10/11	76	7/1/2011
7/18/11	51

<tbody>
</tbody>

 

[Marcelo Branco]

It seems the formula above uses the entire range..Not exactly what i've suggested, but you said it's working fine...

M.