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

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert a text string into a date? JJMCDD02 Excel Worksheet Functions 4 November 25th 05 12:35 PM
Converting number or text to a Date Format samhain New Users to Excel 2 October 17th 05 02:28 PM
Macro to convert text to date Nortos Excel Worksheet Functions 2 May 11th 05 10:42 AM
Change Text Data to Date Charles Excel Discussion (Misc queries) 2 April 26th 05 08:11 PM
EXTRACT TEXT FROM A DATE Ronbo Excel Worksheet Functions 5 February 1st 05 07:39 AM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017