What exactly do you have in D2:D232? 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)
On Thu, 5 Feb 2009 09:29:21 -0800, drose
wrote:
The error i'm getting is (A vlaue used in the formula is the wrong data type.
{=MAX(IF(MONTH(D2:D232)=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