1. filter the data, as that date must be visible (this is you want to delete)
2. Select the data and go to home in ribbon of excel and select the "find & select" button an click on "Go To Special"
3. Check visible cells only. This will now select only the visible cells that you wish to delete
4. Click delete>rows of sheet. ok