Why formula isn't working?

[drose]

The error i'm getting is (A vlaue used in the formula is the wrong data type.

{=MAX(IF(MONTH(D2232)=MONTH(TODAY())-1,H2:H232))}

d2:d232 is either blank or month ex. January
h2:h232 is either blank or a whole number ex.2, 5, 8, 12
Thanks,
Paul

 

[Chip Pearson]

What exactly do you have in D2232? In order to use the MONTH
function, those values must be actual dates, not month names or
numbers. An element like MONTH("March") will fail because "March" is
not a date.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Gary''s Student]

The items in D2 thru D232 need to be Dates for the formula to work.

 

[drose]

I tried it with 1/1/2009 and still doesn't work. Any ideas?

 

[Rick Rothstein]

Using your original set up (where you only had the month name, as text, in
column D), try this array-entered formula...

=MAX(IF(D2232=TEXT(MONTH(TODAY()-DAY(TODAY())),"mmmm"),H2:H232))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself