Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to CONCATENATE two dates field together

Concatenating two date fields in Excel

Instead of using the
Code:
CONCATENATE
function, you can use the ampersand (&) symbol to join the two date fields together. Here's how you can do it:
  1. Select the cell where you want to display the concatenated date range.
  2. Type in the formula
    Code:
    =TEXT(A1,"m/d/yy") & " - " & TEXT(B1,"m/d/yy")
    , where A1 and B1 are the cells containing the two dates you want to concatenate.
  3. Press Enter to apply the formula.

This formula uses the
Code:
TEXT
function to format the dates as text, and then joins them together with the ampersand symbol and a hyphen (-) in between.

For example, if cell A1 contains the date 1/1/04 and cell B1 contains the date 12/31/04, the formula would look like this:
Code:
=TEXT(A1,"m/d/yy") & " - " & TEXT(B1,"m/d/yy")
. The result would be "1/1/04 - 12/31/04".
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
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.



  #4   Report Post  
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.

  #5   Report Post  
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.
.



  #6   Report Post  
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.

  #7   Report Post  
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 09:43 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM
due dates Niki New Users to Excel 4 January 10th 05 05: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 08:35 PM


All times are GMT +1. The time now is 11:14 AM.

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

About Us

"It's about Microsoft Excel"