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!
<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
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