Date Text
 

Hello,

This formula:

=TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

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.

Date Text
 

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.

Thanks


"Jim" wrote:

Hello,

This formula:

=TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

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.

Date Text
 

Try: ="Week of " & TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jim" wrote in message
...
Hello,

This formula:

=TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

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.

Date Text
 

Try:

="Week of "&TEXT(B282-1,"mmm d")& " - " &TEXT(B306+1,"mmm d")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jim" wrote in message
...
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.

Thanks


"Jim" wrote:

Hello,

This formula:

=TEXT(B282,"mmm d")& " - " &TEXT(B306,"mmm d")

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.