Hi
The code looks for a cell with mm/dd/yyyy format & if it finds one in column A, it will delete everything in the cell. If it's formatted as something other than mm/dd/yyyy, it ignores it. The dates on the attachment I posted are mainly dd/mm/yyyy, so when the code is run it deletes the few cells formatted as mm/dd/yyyy & leaves the rest untouched

If you're having a problem attach an example workbook so I can see whats what



Cheers