A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to CONCATENATE two dates field together



 
 
Thread Tools Display Modes
  #1  
Old December 23rd 04, 02:41 PM
Lisa
external usenet poster
 
Posts: n/a
Default 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  
Old December 23rd 04, 02:53 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default

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  
Old December 23rd 04, 02:55 PM
tjtjjtjt
external usenet poster
 
Posts: n/a
Default

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  
Old December 23rd 04, 02:57 PM
Jason Morin
external usenet poster
 
Posts: n/a
Default

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  
Old December 23rd 04, 02:58 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default

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  
Old December 23rd 04, 03:18 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:21 AM.


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