|
| 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
December 23rd 04, 02:41 PM
|
|||
|
|||
How to CONCATENATE two dates field together
I am trying to concantenate 2 dates field together like 1/1/04 & 12/31/04
into 1 field showing 1/1/04 - 12/31/04 but not able to use the concatenate function for it convert to data to a number. Any help is appreciated. 
|
| Ads |
|
#2
December 23rd 04, 02:53 PM
|
|||
|
|||
|
Hi
try =TEXT(A1,"MM/DD/YY") & " - " & TEXT(B1,"MM/DD/YY") -- Regards Frank Kabel Frankfurt, Germany Lisa wrote: > I am trying to concantenate 2 dates field together like 1/1/04 & > 12/31/04 into 1 field showing 1/1/04 - 12/31/04 but not able to use > the concatenate function for it convert to data to a number. Any help > is appreciated.
|
|
#3
December 23rd 04, 02:55 PM
|
|||
|
|||
|
Lisa,
The two dates are in A7 and A8 for this example: =TEXT(A7,"m/d/yyyy")&" - "&TEXT(A8,"m/d/yyyy") tj "Lisa" wrote: > I am trying to concantenate 2 dates field together like 1/1/04 & 12/31/04 > into 1 field showing 1/1/04 - 12/31/04 but not able to use the concatenate > function for it convert to data to a number. Any help is appreciated.
|
|
#4
December 23rd 04, 02:57 PM
|
|||
|
|||
|
Try:
=TEXT(A1,"mm/dd/yy")&" - "&TEXT(B1,"mm/dd/yy") HTH Jason Atlanta, GA >-----Original Message----- >I am trying to concantenate 2 dates field together like 1/1/04 & 12/31/04 >into 1 field showing 1/1/04 - 12/31/04 but not able to use the concatenate >function for it convert to data to a number. Any help is appreciated. >. >
|
|
#5
December 23rd 04, 02:58 PM
|
|||
|
|||
|
one way:
=TEXT(A1,"m/d/yy") & TEXT(B1,"m/d/y") In article >, "Lisa" > wrote: > I am trying to concantenate 2 dates field together like 1/1/04 & 12/31/04 > into 1 field showing 1/1/04 - 12/31/04 but not able to use the concatenate > function for it convert to data to a number. Any help is appreciated.
|
|
#6
December 23rd 04, 03:18 PM
|
|||
|
|||
|
Whoops, try
=TEXT(A1,"m/d/y - ")&TEXT(B1,"m/d/y") In article >, JE McGimpsey > wrote: > one way: > > =TEXT(A1,"m/d/yy") & TEXT(B1,"m/d/y")
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I concatenate information in Excel and keep the number form | DaveAg02 | Excel Worksheet Functions | 7 | May 9th 08 07:44 PM |
| Pivottable Dates | JayBee | Excel Discussion (Misc queries) | 5 | January 15th 05 08:43 PM |
| Formating Dates for production schedule | dpl7579 | Excel Discussion (Misc queries) | 1 | January 11th 05 08:43 PM |
| due dates | Niki | New Users to Excel | 4 | January 10th 05 04:11 PM |
| I get wrong dates when i paste from a different sheet into a new s | mmollat | Excel Discussion (Misc queries) | 2 | January 6th 05 07:35 PM |
Linear Mode
