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???
|