Extracting date

[ExcelNewby]

In cell B2 is Date: 7/17/08 - 7/17/08 and I want to extract 7/17/08 into cell
E3. Could someone assist?


Thank you.
ExcelNewby

[NBVC]

Try

=left(A1,find("-",A1)-2)+0

format cell as date...

[ExcelNewby]

I'm getting #VALUE! as a return and I don't know why???

Thank you.
ExcelNewby

[NBVC]

Did you change the A1's to B2's to suit your cell reference?

=left(B2,find("-",B2)-2)+0

[ExcelNewby]

Yes, I did replace A1 with B2 and formatted cell E3 as Date. Do you think the word Date in B2 has anything to do with it?


ExcelNewby

[NBVC]

Sorry, I didn't catch that "Date:" is also in the cell string...

try:

=MID(A1,FIND("Date: ",A1)+6,FIND("-",A1)-FIND("Date:",A1)-7)+0

[ExcelNewby]

Yeah!!! You did it. Thank you for making my weekend. If you were living any closer you would have get free babysitting service..maybe when you visit Atlanta.

Thanks again.

[NBVC]

If both dates in the string are always the same, then this simpler formula should do it too!

=MID(A1,FIND("-",B2)+2,255)+0