Forum Discussion

Yugandhar__Y's avatar
Yugandhar__Y
Copper Contributor
Jan 18, 2026

Merging FROM and TO dates to 1 cell

Hello!!

 

I have the FROM date as 01-01-2026 and the TO date is 07-01-2026.

I wish to have 01-01-2026 TO 07-01-2026 as the heading of this column.

Please suggest

excel

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 18, 2026

    Hi

    Not knowing:

    • Version of Excel you use, assumed >/= 2021
    • How dates are formatted according to your Regional Settings, assumed dd-mm-yyyy
    • Where your TO/FROM dates seat on the sheet, assumed FROM below TO

    in C2 above:

    =TEXTJOIN( " TO ",, TEXT( C3:C4, "dd-mm-yyyy" ) )

Resources