Concatenate date + date + value in kg

Hi, i am trying to make a string with these 3 cells: 2 have a date and 1 has a numeric value in kg. sadly it comes out like this:

martedì 19 dicembre 2017 (format dd/mm/yyyy)
+
mercoledì 24 gennaio 2018 (format dd/mm/yyyy)
+
108
=
430884312443111

I tried to tell excel to read the date as a string but i'm not quite able yet... text function is not within my powers i guess...

ATTACHMENT ADDED

What do you want it to return?

You can't use date format on a cell that contains more than a simple single date or date/time value in it.

Attach a sample workbook.

Please attach a sample workbook.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

yeah i added the attachment in the main post =) thx! (i would like a text string in return, so i will use that as an unique link to link to clients) - i could aslo use the numeric result, but itat would make things much more complicated

I think this is what you want (change to suit your locale):

=TEXT(A2,"dd/mm/yyyy")&" "&TEXT(B2,"dd/mm/yyyy")&" "&I2

Don't worry - glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

That's why I said this:

(change to suit your locale)

Ali ROCKS

Thanks.