I have a long list of file names in an excel spreadsheet which come in all shapes and sizes, the only consistent is that in the file is a month/year in the format of MMMM YYYY (eg December 2019) - where this exists in the file name varies.

How can I extract this date from the text? I will ultimately want the last date in the month so will use EOMonth function to get the day element of the date.

Thanks for your help