Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE gives #VALUE! error
I have in cell A25 the text "- 6/19/2007 6:22:12 PM". The formula
=DATEVALUE((TRIM(MID(A25,FIND("-",A25)+3,11)))) is giving me a #VALUE! error. How can I get it to return the correct date? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
datevalue() | Excel Worksheet Functions | |||
=DATEVALUE | Excel Worksheet Functions | |||
=DATEVALUE("7/1/20"&MID(C3,13,2)) creates error | Excel Worksheet Functions | |||
datevalue | Excel Worksheet Functions | |||
datevalue | Excel Worksheet Functions |