Macro to retain last 2 months

I have dates in Col E. I have tried to write code to retain the last two months and delete all the other dates.

My dates are in format dd/mm/yyyy

In this example I want to Retain all the dates containing June 2023 and 2023 and delete the rest from row 2 onwards


I have highlighted the dates to retain in yellow

It would be appreciated if someone could kindly amend my code

Please Login or Register  to view this content.

Thanks for the help. I need to retain the month and years for the last 2 months being June 2023 and May 2023 in this example. The last month is June 2023 and the Prior month is May 2023, so these must be retained

The items in Blue must be deleted

Please test & amend

Please try this.

Please Login or Register  to view this content.

Many thanks for the help Bytemarks


Your code works 100%