Set a month as range based on single date in one cell

[mexcel300]

I have dates in a row formatted as month/year, i.e. April 2011(4/1/2011). I need a cell under this date to match the April 2011 date to the same month and year in a column on another sheet that has daily dates and select that whole month (April) as the range. Once that range it selected I need it to find a maximum value from the column 2 to the right. Thanks in advance for any help, Mike

 

[asma410]

Looks like a VBA code. Try recording a macro & do this task manually. Then you can run this macro to do the same thing automatically. You can tweak the code a little to fit any conditions.

 

[mexcel300]

I dont think recording the macro will be able to tell it that it selected the range based on something or that I'm looking for a max value...