I agree with what Tom wrote--put those dates in their own cells. It'll make
life much simpler.

But if you can't:

=DATEVALUE(MID(A1,SEARCH(" - ",A1)+3,255))
-DATEVALUE(LEFT(A1,SEARCH(" - ",A1)-1))
(All one cell)

And if your dates are formatted consistently with your windows setting (mdy in
both spots).

dstock wrote:

Suppose cell A2 has 6/27/05 - 7/1/05
A3 has 7/4/05 - 7/8/05... and so
I need to know the formula to coomputer the number of days between
those dates, which is obviously 5. The reason it need to keep the range
in one cell is this will be used in a VLookup function. Thanks!

--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=381328

--

Dave Peterson