Yes, there is an easier way to convert the "Text with 2-digit year" format to a date format that can be filtered. You can use the
Text to Columns feature in Excel to convert the text to dates.
Here are the steps to follow:
- Select the cells that contain the "Text with 2-digit year" format.
- Click on the Data tab in the ribbon.
- Click on the Text to Columns button.
- In the Convert Text to Columns Wizard, select the Delimited option and click Next.
- In the next step, make sure that only the "Space" option is selected as a delimiter and click Next.
- In the next step, select the column that contains the date and choose the "Date" option under Column data format.
- Select the date format that matches the format of your dates (e.g. MDY for month-day-year format) and click Finish.
Excel will then convert the "Text with 2-digit year" format to a date format that can be filtered. You can now use the
filter function to filter the dates as needed.