Sumproduct not handling MONTH()

[D4rwin]

Can someone tell me why this formula is not working properly?
The purpose is to test whether the date is the most recent date per month. It is supposed to return a TRUE in both cases as they are different months.

​

Formula	Result	Date
=B2=SUMPRODUCT(MAX((MONTH(B2)=MONTH($B$2:$B$3))*$B$2:$B$3))	False	42123
=B3=SUMPRODUCT(MAX((MONTH(B3)=MONTH($B$2:$B$3))*$B$2:$B$3))	True	42124

<tbody>
</tbody>

Thanks

 

[Aladin Akyurek]

Is it not just...

=B2=MAX($B$2:$B$3)

which needs just enter?

 

[D4rwin]

No that will certainly not work as BOTH cases must return TRUE as they are the maximum values for the given months.
My data contains several dates per month and I must determine which one is the last date (and data point) in each month.
But it seems that sumproduct is not handling it correctly.

 

[Aladin Akyurek]

No that will certainly not work as BOTH cases must return TRUE as they are the maximum values for the given months.
My data contains several dates per month and I must determine which one is the last date (and data point) in each month.
But it seems that sumproduct is not handling it correctly.

Would you post a 5 row sample along wıth the desıred results, not the results of a non-working formula?