Identify duplicate rows and delete all but the most recent

Good afternoon
I’d like to introduce myself, recently retired from the military and working on a job conducting analysis of business process. Pretty good at excel but a novice at using VBA. I have a large spreadsheet with over 700 rows. I would like to identify all the duplicate rows using column “account number” and then use the “date completed” column to identify the most recent row and delete all older duplicate rows. I have used conditional formatting to identify the dups but don’t know how to sort their rows by date and delete the older ones. Think my answer is to use VBA but I haven’t done something this complex. Really could use someone’s help. I have attached a small sample of the spreadsheet I’m working with. Thanks