Date Comparison

[SWLee]

I need a formula that works for both two digit and 1 digit months. I add multiple records at a time, and the actual date can vary widely. I can use one formula and then make corrections, but would like something that works wither way. Thanks in advance!

Column BM	Column BN	Column BO
Actual Date	Month	Month Check	Result
9/27/2013	2013-9	=(LEFT(BM1,1)-RIGHT(BN1,1)=0	TRUE
10/12/2013	2013-10	=(LEFT(BM1,1)-RIGHT(BN1,1)=0	FALSE

<tbody>
</tbody>

The date in Column BM is populated by a formula referring to a cell in a query - I can't modify it - always returns the 1st 9 months as a single integer and the last 3 months as a double integer
The date in Column BN is manually populated

This is used to error check the manual entries in column BN

 

[bschwartz]

Can you post the results of this, and the specific alteration of this formula you are using?

=LEFT(BM2,FIND("/",BM2)-1)=RIGHT(BN2,LEN(BN2)-FIND("-",BN2))

 

[SWLee]

I just realized I have a typo in the original question, and that must be what is causing your solutions to fail. In column BN, the months are all double integer (09 for September and 10 for October - my example mistakenly shows September with a single integer, 9)!!!

 

[bschwartz]

That might explain it...

Try this instead: =VALUE(LEFT(BM2,FIND("/",BM2)-1))=VALUE(RIGHT(BN2,LEN(BN2)-FIND("-",BN2)))

 

[SWLee]

Bingo! That did it! thanks to all of you, and I really am sorry about wasting your time with that typo!

 

[bschwartz]

Not a problem. Glad it worked out...

 

[mfexcel]

hope you can understand how and why it works

Bingo! That did it! thanks to all of you, and I really am sorry about wasting your time with that typo!