Forum Discussion
Solved
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
Thanks for the feedback. Feel free to click Mark as solution (at the bottom of the post) to help people who Search for existing solution. Thanks for them
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 TO below FROM
in C2 above:
=TEXTJOIN( " TO ",, TEXT( C3:C4, "dd-mm-yyyy" ) )Hello Yugandhar__Y
Did this work? Do you need any adjustment?
Sir,
Thankyou very much. It did really as per expectation.
Thankyou soooo much sir
Thanks for the feedback. Feel free to click Mark as solution (at the bottom of the post) to help people who Search for existing solution. Thanks for them
