Combining from and to dates

[aproberts1980]

Is there a way to combine two dates from two separate cells to one.

example

From	To	From-To
01/01/2020	15/01/2020	01/01/2020-15/01/2020

 

[Joe4]

Sure. Let's say that your two dates are in cells A2 and B2. Then enter this formula in cell C2:
=TEXT(A2,"dd/mm/yyyy") & "-" & TEXT(B2,"dd/mm/yyyy")

 

[alansidman]

Yes, but they will become text and not functional dates.

=CONCATENATE(A2 &"-"&B2)

 

[Joe4]

Yes, but they will become text and not functional dates.

=CONCATENATE(A2 &"-"&B2)

Just note that if the values in A2 and B2 are really date entries, and not text entries, then this will return:
43831-43845
which is the numeric value of the dates (that is how Excel sees them, the number of days since January 0, 1900).
That is why I applied the TEXT function to each value, to get it to show the format you expect.

Alan,
It looks like you also blended both Concatenate actions, i.e. it is typically written:
=A2 & "-" & B2
or
=CONCATENATE(A2,"&",B2)

To use both "CONCATENATE" and "&" in the same formula is redundant and unnecessary.

 

[alansidman]

Joe,

Senior moments some times overtake me when I work to fast without thinking. Thanks.

Alan

 

[Joe4]

Senior moments some times overtake me when I work to fast without thinking. Thanks.

No worries Alan! I have them myself (especially on Monday mornings), but I cannot blame it on my age (not quite there yet).
It feels like I have gotten "dumber" since having kids (I blame it on lack of sleep).