Remember Me?

#1
January 4th 06, 02:04 PM posted to microsoft.public.excel.worksheet.functions
 Jim Posts: n/a
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.

#2
January 4th 06, 02:09 PM posted to microsoft.public.excel.worksheet.functions
 Jim Posts: n/a
Date Text

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.

#3
January 4th 06, 02:10 PM posted to microsoft.public.excel.worksheet.functions
 Max Posts: n/a
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.

#4
January 4th 06, 09:21 PM posted to microsoft.public.excel.worksheet.functions
 Max Posts: n/a
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
...

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JJMCDD02 Excel Worksheet Functions 4 November 25th 05 12:35 PM samhain New Users to Excel 2 October 17th 05 02:28 PM Nortos Excel Worksheet Functions 2 May 11th 05 10:42 AM Charles Excel Discussion (Misc queries) 2 April 26th 05 08:11 PM Ronbo Excel Worksheet Functions 5 February 1st 05 07:39 AM

All times are GMT +1. The time now is 04:39 AM.