Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date from Right Formula
I need a formula that will extract the last date from these type of
strings. 07/12/2006 07/12/2006 07/12/2006 07/17/2006 - - Or 07/12/2006 - Or 07/07/2006 07/07/2006 - - - - -Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date from Right Formula
One way:
=MID(A1, FIND("^", SUBSTITUTE(A1, "/", "^", LEN(A1) - LEN(SUBSTITUTE(A1, "/", "")))) - 5, 10) " wrote: I need a formula that will extract the last date from these type of strings. 07/12/2006 07/12/2006 07/12/2006 07/17/2006 - - Or 07/12/2006 - Or 07/07/2006 07/07/2006 - - - - -Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date from Right Formula
uh - - - WOW - I don't know how you guys keep coming up with this
stuff, but this worked perfectly the 1st time. Great work, thanks for the help. JE McGimpsey wrote: One way: =MID(A1, FIND("^", SUBSTITUTE(A1, "/", "^", LEN(A1) - LEN(SUBSTITUTE(A1, "/", "")))) - 5, 10) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Date from Right Formula
Another way... =RIGHT(TRIM(SUBSTITUTE(A1,"-","")),10) gives a text result, as does previous suggestion. For a true date =RIGHT(TRIM(SUBSTITUTE(A1,"-","")),10)+0 format as date -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=562280 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
extract name when a date in another cell gets near | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |