Monthly Averages

[Lukael]

Hi,

I have dates (January, February) in column A, and values in column C. I want to calculate averages for months.

I have attached a sample worksheet, but note that in original workboook I have dates for all year, so I need averages for all months.

I also need some formula solution that I could use in other worksheets where year is not same. Simple formula is not an option in this case, because February days are not same every year. I know there is something with pivot tables that I could do, but can't figure It on my own, so I'd prefer a formula which checks month in column A and calculates corresponding values in column C, with total result of their average.

Any help much appreciated !!