Want to select only date of a column and if date not weekend then delete

Thank you for the guidance. Attached is the sample workbook. First worksheet is how it is (before) and the second worksheet is how it should be (after). The results doesn't need to be on a new worksheet, I just made an other worksheet (after) to show how it should look after. Thank you.