Hello,
I have a spreadsheet wherein dates are stored as Text, I want to convert them to date format mm/dd/yyyy and then filter dates to NOT include current month. So, for example I don't want anything from Sept to show up, I only want prior months. Please note, I have other data on the left & right of date column. I want to do this using VBA.
Any help would be much appreciated. Thanks!
I have a spreadsheet wherein dates are stored as Text, I want to convert them to date format mm/dd/yyyy and then filter dates to NOT include current month. So, for example I don't want anything from Sept to show up, I only want prior months. Please note, I have other data on the left & right of date column. I want to do this using VBA.
Any help would be much appreciated. Thanks!
Date |
2021-08-25 |
2021-08-25 |
2021-08-25 |
2021-01-14 |
2021-05-31 |
2021-05-31 |
2021-09-03 |
2021-09-03 |
2021-09-03 |