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!