A1 = SUM + "text" + SUM

[ThomasCarter]

For example I want A1 to be a range of dates.

I want it to be the value of C1 + 3 (So 3 days after C1) then I want a spaced dash to represent that it's a range of dates " - " and finally I want a second date which is C1 + 5 (So 5 days after C1)

This should read "19/04/2013 - 21/04/2013"

Is this possible?

[Andrew-R]

Yes:

=TEXT(C1+3,"dd/mm/yyyy") & " - " & TEXT(C1+5,"dd/mm/yyyy")

[jkray622]

I believe the following function should work:
=concatenate(C1+3," - ",C1+5)

Concatenate allows you to combine values from multiple cells into a single cell.

[ThomasCarter]

Hi,

Andrew. Works perfect, thanks.

JK, sadly this doe snot work for dates but I see where you're coming from and I'm sure this will come in handy for other things in future.

Thanks both. Thread solved.

[jkray622]

Thomas,

My apologies. It works, but with a slight modification. Andrew's might be simpler, but here is the corrected solution using CONCATENATE:

=CONCATENATE(TEXT(C1+3,"MM/DD/YYYY")," - ",TEXT(C1+5,"MM/DD/YYYY"))

I had to use the TEXT function to return the date value in the format you wanted.

Hope this helps (if not in this, in future functions)!