If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text and Date
I would like to end up with something like "Week of May 14 to May 18", but
when I combine the text with the date (from another cell), the date shows up as a serial number. If necessary, I can break this use as many as three cells. Scafidel Louisiana |
#2
|
|||
|
|||
Text and Date
Do you have both dates in separate cells? Like this:
A1 = May 14 (formatted as DATE) A2 = May 18 (formatted as DATE) ="Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd") You may want to make sure there are in fact dates in both cells, otherwise, an empty cell will return Jan 00: =IF(COUNT(A1:A2)2,"","Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd")) Biff "Scafidel" wrote in message ... I would like to end up with something like "Week of May 14 to May 18", but when I combine the text with the date (from another cell), the date shows up as a serial number. If necessary, I can break this use as many as three cells. Scafidel Louisiana |
#3
|
|||
|
|||
Text and Date
Thanks, Biff. This Discussion Group always comes to the rescue!
Scafidel Louisiana "T. Valko" wrote: Do you have both dates in separate cells? Like this: A1 = May 14 (formatted as DATE) A2 = May 18 (formatted as DATE) ="Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd") You may want to make sure there are in fact dates in both cells, otherwise, an empty cell will return Jan 00: =IF(COUNT(A1:A2)2,"","Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd")) Biff "Scafidel" wrote in message ... I would like to end up with something like "Week of May 14 to May 18", but when I combine the text with the date (from another cell), the date shows up as a serial number. If necessary, I can break this use as many as three cells. Scafidel Louisiana |
#4
|
|||
|
|||
Text and Date
You're welcome. Thanks for the feedback!
Biff "Scafidel" wrote in message ... Thanks, Biff. This Discussion Group always comes to the rescue! Scafidel Louisiana "T. Valko" wrote: Do you have both dates in separate cells? Like this: A1 = May 14 (formatted as DATE) A2 = May 18 (formatted as DATE) ="Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd") You may want to make sure there are in fact dates in both cells, otherwise, an empty cell will return Jan 00: =IF(COUNT(A1:A2)2,"","Week of "&TEXT(A1,"mmm dd")&" to "&TEXT(A2,"mmm dd")) Biff "Scafidel" wrote in message ... I would like to end up with something like "Week of May 14 to May 18", but when I combine the text with the date (from another cell), the date shows up as a serial number. If necessary, I can break this use as many as three cells. Scafidel Louisiana |
Thread Tools | |
Display Modes | |
|
|