| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Numbers to Text or Date to Text | Excel Discussion (Misc queries) | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Date from text to Date format | Excel Worksheet Functions | |||
| text date to date format | Excel Discussion (Misc queries) | |||
Linear Mode
