Formula to Extract month and year from Text

I have text in Cell A1 and it contains a date at the end fore eg 31 May 2022


I have used a formula to extract the month and year below but if the date at the end is for eg 30 April 2022, it returns #value

Please Login or Register  to view this content.

It would be appreciated if someone could kindly amend my formula

Cell C1 formula , Drag down

Formula:

Please Login or Register  to view this content.

Thanks for the help. Code works perfectly

@Howardc1001 You're Welcome. Glad to help . Thank You for the feedback and rep.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".