Max Weekend Value, display date value was seen

johnjacob,

Attached is a modified version of your posted workbook.

I created 2 named ranges to avoid errors when performing the Weekday() function.
The first named range is for the days and I named it rngDays. Here is the formula it uses:

Please Login or Register  to view this content.

The second named range is for the values and I named it rngValues. here is the formula it uses:

Please Login or Register  to view this content.

In cell J6 and J8 are array formulas. Note that array formulas must be entered with Ctrl+Shift+Enter and not just Enter.
The array formula in J6:

Please Login or Register  to view this content.

The array formula in J8:

Please Login or Register  to view this content.

Lastly, to get the corresponding dates, I used Index/Match. Index/Match is a regular formula.
For the weekend max:

Please Login or Register  to view this content.

For the weekend min:

Please Login or Register  to view this content.

For the Month Max:

Please Login or Register  to view this content.

For the Month Min:

Please Login or Register  to view this content.

You're very welcome

To create a named range, you can go to the Formulas tab on the ribbon and then click Name Manager.

Here's some links to information on creating dynamic named ranges:
http://support.microsoft.com/kb/830287
http://office.microsoft.com/en-us/ex...001126115.aspx
http://www.contextures.com/xlNames01.html#Dynamic
http://www.cpearson.com/Excel/excelF.htm#DynamicRanges