Morning All

Sorry, having complete brain fade this morning and can't find an answer searching the forum either.

I have 2 columns

Column A contains a value
Column B contains a date eg displayed as 15/5/2012

In Column C I wish to display the value from Column A for all of the days in May 12

This will continue for the rest of the dates which are spread over a 12 month period. I can edit these accordingly.

Can't seem to fathom this.

Any help would be gratefully received.

Steven811