Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates
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 "Mike H" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |