Delete rows based on date range

Hello,

I am trying to write a simple macro that will delete a row of data if the date is not in a certain range (in this particular case, if it is not within a certain year range). The data will always have an unknown number of rows, and the dates are always formatted as MM/DD/YYYY and located in column B. I was thinking I can do some sort of Do-While loop until it reaches two empty cells, but I'm not sure how to specify the date range. Any suggestions or help would be greatly appreciated.

Thank you.

This should get you started in the right direction.

Please Login or Register  to view this content.

Thank you! It did help! I actually decided to go this route, also I moved the date range to Column A:

Please Login or Register  to view this content.