Averageif(range,monthcriteria,[average range])???

Hello All,

How do I set the criteria for an AverageIF formula to pull all records in column B:B that are =March. Format of B:B is m/dd/yyyy

With AVERAGEIF (and others like SUMIF, COUNTIF etc.) you can't manipulate the range, so it would be better to use AVERAGEIFS so you can use 2 conditions:

=AVERAGEIFS(average_range,B:B,">="&DATE(2013,3,1),B:B,"<"&DATE(2013,4,1))

i.e. greater than or equal to 1st March 2013 AND less than 1st April 2013.

Hope this helps.

Pete