Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel spreadsheet with over 10,000 entries. This spreadsheet contains two columns of dates, and I need to select only those entries where the dates do NOT match in the two columns.

The problem is, the dates have been differently formatted and are embedded within other information, like this: $obj->parsedDate('>=','1997','3','1')

Sometimes the two columns have used exactly the same formatting and I can exclude these using the IF function. However in many cases the date may have been entered differently in the second column, like $obj->parsedDate('>=',1997,3,1) vs $obj->parsedDate(">=",1997,3,1), so the numbers will be the same but some of the other characters will not not.

Can Excel look for just the numbers and identify matches in this way?

share|improve this question

Try this formula to convert the text into dates:


It is built on the assumption that the first comma in all cells is just in front of the date, like all three dates in your data sample show. If that assumption is wrong, you may need to provide some other pointer that always exists in the data, so it can be converted.

Format the result with the data format of your choice. Apply this formula to both columns and a comparison will be easy.

enter image description here

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .