Forum Discussion
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
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" ) )