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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us