Concatenate dates - getting odd result

**irish1two3** · 03-16-2007, 10:54 AM

I have dates in 2 columns. I want to concatenate those onto a form as follows:

D2 4/14/07
E2 4/15/07

F2 =CONCATENATE(TEXT(D2,"dd/mm/yy")," to ",TEXT(E2,"dd/mm/yy"))

What I'm getting as a result is "30/03/07 to 02/04/07"

I've tried reformatting the columns to date, test & general and I'm sure it's something stupid that I'm missing, but I can't figure it out.

**arthurbr** · 03-16-2007, 11:08 AM

are d2 and e2 numbers or text?
( just to make sure, try =d2&"to"&e2)

**oldchippy** · 03-16-2007, 11:15 AM

Hi

I've just changed the dates in D2 (14/04/07) & E2 (15/04/07) and it works fine

= 14/04/07 to 15/04/07

**irish1two3** · 03-16-2007, 11:21 AM

I entered the date in D2 & E2 as dates (american format mm/dd/yy) I tried using the simple concatenate (D2&"to"&E2) and I got the serial number format of the dates (39171 to 39174)

Does Excel expect the dates to be in a European format? (dd/mm/yy)

**oldchippy** · 03-16-2007, 11:29 AM

It shouldn't matter, take a look at attached

**irish1two3** · 03-16-2007, 01:07 PM

Thanks for the file. I couldn't see any differences in my coding and couldn't get it to work so I just scrubbed the entire page and re-wrote it. It's working now, but I sure can't figure out what I did to mess it up in the first place.

Thanks for the help