Please check the below formula will help you
It works until 8-Jan then stops. BTW there is an extra space between "a" and "l" for some reason that causes the formula to return #VALUE! errors.

I don't think you can do this via a formula. I could be wrong, but it needs a macro in my humble opinion.

Robert