Tom, I think you've missed the actual question here, which is that the
dates are entered incorrectly onto the sheet - you could use a macro or
formulas to get the relevent parts of the date and convert them INTO a
date - do this with formulas in a blank column, then copy the values
over the originals - if not clear, you can get me at