For better analysis, I have 2 questions:
- Will the length of text in column A change? For example, "DOB" changes to be other text with different length instead of 3.
- If the year becomes 2024, such as 2024-1-27, what's the result you need in column B?
Currently, I suggest you try formula =VALUE(MID(A2,FIND("-",A2)+1,2))+11
to have a check.
Any updates, welcome to post back.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.