Max formula not working.

[omairhe]

The max formula is not working with range D16 and D17.

Value in D16 = 202103
Value in D17 = 202104

Formula in D16 = "=MID(D9,FIND("-",D9)+1,4)&LEFT(D9,2)"
Formula in D17 = "=MID(D10,FIND("-",D10)+1,4)&LEFT(D10,2)"

Thanks and will appreciate.

 

[mrshl9898]

Change the formula results to numbers

=NUMBERVALUE(MID(D9,FIND("-",D9)+1,4)&LEFT(D9,2))
=NUMBERVALUE(MID(D10,FIND("-",D10)+1,4)&LEFT(D10,2))