software

Hello,

This formula:

=TEXT(B282,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306,quot;mmm dquot;)

To produce the following:

Jan 2 - Jan 6

What I would like to do is have the result show this:

Week of Jan 2 - Jan 6

Thanks for the help.In addition,

I need to know how to write the formula to show the start date (-1) minus 1
day and the end date ( 1) plus one day.

Thanksquot;Jimquot; wrote:

gt; Hello,
gt;
gt; This formula:
gt;
gt; =TEXT(B282,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306,quot;mmm dquot;)
gt;
gt; To produce the following:
gt;
gt; Jan 2 - Jan 6
gt;
gt; What I would like to do is have the result show this:
gt;
gt; Week of Jan 2 - Jan 6
gt;
gt; Thanks for the help.
gt;

Try: =quot;Week of quot; amp; TEXT(B282,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306,quot;mmm dquot;)

--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Jimquot; gt; wrote in message
...
gt; Hello,
gt;
gt; This formula:
gt;
gt; =TEXT(B282,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306,quot;mmm dquot;)
gt;
gt; To produce the following:
gt;
gt; Jan 2 - Jan 6
gt;
gt; What I would like to do is have the result show this:
gt;
gt; Week of Jan 2 - Jan 6
gt;
gt; Thanks for the help.
gt;
Try:

=quot;Week of quot;amp;TEXT(B282-1,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306 1,quot;mmm dquot;)

--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Jimquot; gt; wrote in message
...
gt; In addition,
gt;
gt; I need to know how to write the formula to show the start date (-1) minus
1
gt; day and the end date ( 1) plus one day.
gt;
gt; Thanks
gt;
gt;
gt; quot;Jimquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; This formula:
gt; gt;
gt; gt; =TEXT(B282,quot;mmm dquot;)amp; quot; - quot; amp;TEXT(B306,quot;mmm dquot;)
gt; gt;
gt; gt; To produce the following:
gt; gt;
gt; gt; Jan 2 - Jan 6
gt; gt;
gt; gt; What I would like to do is have the result show this:
gt; gt;
gt; gt; Week of Jan 2 - Jan 6
gt; gt;
gt; gt; Thanks for the help.
gt; gt;