Dates

[Donna]

Pull latest (most current)date in the cell
Example:All this is in one cell

Permanent Exception 10/22/09 stmt* 9/05/09 inv 1235 $700.00 can pending
cr*8/05/09 em re coa's $500.00

The text is not consistant, the date may be at the very beginning of the
cell or their may be information preceeding the date.

I would like to pull out the latest date (most current date)
In the example above what I would like for it to look like:

1st column: All information before the date: Permanent Exception
2nd column: Latest date (the last date entered) 10/22/09
3rd column: All information after the latest date: stmt* 9/05/09 inv 1235
$700.00 can pending cr*8/05/09 em re coa's $500.00

Thanks
Donna

 

[Mike H]

Donna,

Is the latest date always the first date to appear in the cell or could
there be another date before the latest date?

Mike

 

[Donna]

Yes, it should be. The only other date would be in a month/year format such
as 10/09 but I do not want to count that as my latest date.
Thanks
Donna