Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 04, 02:41 PM
Lisa
 
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.

  #2   Report Post  
Old December 23rd 04, 02:53 PM
Frank Kabel
 
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   Report Post  
Old December 23rd 04, 02:55 PM
tjtjjtjt
 
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   Report Post  
Old December 23rd 04, 02:57 PM
Jason Morin
 
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   Report Post  
Old December 23rd 04, 02:58 PM
JE McGimpsey
 
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   Report Post  
Old December 23rd 04, 03:18 PM
JE McGimpsey
 
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")



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 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:36 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017