Multiple dates in one cell...

November 4, 2015 at 08:58:16
Specs: Windows 7
In cells AM9 - AM269 I have a mixture of text and dates (multiple dates may be entered, some of which have strike through) - I need to extract the latest date in order to produce some MI.

How do I extract the last date?

I've already reached out to the users to change the s/s into a better format to no avail as the sheet is used by several users globally.

Any help you can provide would be greatly appreciated. So far ive tried, right & len related formulas but cant seem to get it right.

See More: Multiple dates in one cell...

Report •

November 4, 2015 at 09:42:48
Post a few examples of your data and we'll see if anything can be done.

I'm not sure a formula will work, so you may need a Macro.

And in the future, Excel questions are best asked in the Office Software forum.


message edited by mmcconaghy

Report •
Related Solutions

Ask Question