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