Now you know that you can <g

=TEXT(IF(WEEKDAY(B3,2)<6,B3,B3+(8-WEEKDAY(B3,2))),"m/d/yyy")&" through
"&TEXT(IF(WEEKDAY(C3,2)<6,C3,C3+(8-WEEKDAY(C3,2))),"m/d/yyyy")

--
HTH

Bob Phillips

"Adam" wrote in message
...
Thanks Bob that worked great!

I got one more question:
What if my date range result lands on a weekend and i don't want it to?

Is there a way that i can identify and check that that the result is a
weekend and if it is move the range to the next earliest range?

If possible please use my work email as well ).

Thanks.

"Bob Phillips" wrote:

No need for SUM

=A3+2
=A3+7

=TEXT(B3,"m/d/yyy")&" through "&TEXT(C3,"m/d/yyyy")

--
HTH

Bob Phillips

"Adam" wrote in message
...
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???