Remember Me?

#1
December 23rd 04, 03:41 PM
 Lisa Posts: n/a
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
December 23rd 04, 03:53 PM
 Frank Kabel Posts: n/a

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, 03:55 PM
 tjtjjtjt Posts: n/a

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, 03:57 PM
 Jason Morin Posts: n/a

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, 03:58 PM
 JE McGimpsey Posts: n/a

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, 04:18 PM
 JE McGimpsey Posts: n/a

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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post DaveAg02 Excel Worksheet Functions 7 May 9th 08 07:44 PM JayBee Excel Discussion (Misc queries) 5 January 15th 05 09:43 PM dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM Niki New Users to Excel 4 January 10th 05 05:11 PM mmollat Excel Discussion (Misc queries) 2 January 6th 05 08:35 PM

All times are GMT +1. The time now is 09:07 PM.

The comments are property of their posters.

"It's about Microsoft Excel"