hi
just subtract 1 from MONTH(NOW())

=MAX(IF(MONTH(A2:A11)=MONTH(NOW())-1,B2:B11))

and i might use Today() instead of now() becasue now() has the time
attached to where today() doesn't. month() will strip the time off but if all
you are after is the month, then that may be just less clutter for excel to
trip over. i don't think it would make any profound or noticeable difference
but, hey, a nanosecond here, a couple of bytes there. might add up eventually.

Regards
FSt1

"drose" wrote:

Hi,
The formula below looks at current month, it their a way to look at previous
month?
=MAX(IF(MONTH(A2:A11)=MONTH(NOW()),B2:B11))