I think im doing a terrible job of explaining myself here, but this is the type of formular I'm looking to create, however it needs to be a little more intelligent if possible, picking up the "month" thats closest to the current date, to a maximum of a specified range.

A1:A12 - Months, formatted as 01/01/06 etc.

B1:B12 - Data that needs averaging

Average - C2:C13 - Average(b1if(a2>(Today()),b1,b2))

What I hope to be able to do is in my Average forumla above - change the reference to B1, to the closest month to the current date in the range A1:A12.

Is this possible?