Review 3016 filenames presented in an Excel file.
Each report name includes the report date but in a variety of formats.
Review each filename and extract the date in DD/MM/YYYY format to a separate column.
Indicate the month end report in a separate column.
(Month end reports are the report for that last Friday of the month or any report on the 30th June)