Hello,

I have one cell where i enter a date 8/30/2005 (which resides in A3).

And i need another cell to display a date range based on the above date.
The date range will always be the same number of days apart. For example the
date range will always be 2-7 days from the entered above date. What i did so
far was 2 seperate calculations in 2 different cells. One for the low end
(=SUM(A3+2) and one for the high end =SUM(A3+7). Then I put =(B3) & " " &
"through" & " " & (C3) in the third cell where i want the range to appear.
But what happens is it comes out like:
38596 through 38599

How can i get the dates to remain in date format even though there is text
between them???