I read your formula.
There is a mistake on it.
Please, pay attention at a DAY part of it.
My suggestion:... DAY(MID(A1,3,3))
Your Formula:..... DAY(MID(A1,3,4
Correct the formula and try again.
I hope it will work after it.
Belo Horizonte, Brasil