Hi - I have a list of daily $Amounts for ea day of the year.

ie --Month-- --Date-- --Amount--

In a summary table, I extract the highest AMOUNT for a particular
month with {=MAX(IF(Month="Dec",'9am'!Amount))}

I extract the DATE of the higest AMOUNT for thyat month, Dec, with
{=MAX(((Month)="Dec")*(Amount=MAX(((Month)="Dec")*Amount))*Date)}

I can successfully get the highest AMOUNT and DATE for a particular
MONTH, but modifying the second formula to get the DATE of the lowest
AMOUNT will not work.  It fails because it will return the DATE of the
lowest AMOUNT for the complete year, rather than restricting it to the
month of "Dec".

Can anyone suggest an alternative that will return the DATE of the
lowest AMOUNT for a particular month?

Tks, Kay