Forum Discussion
Solved
JoinCells
What formula will take A1 and B1 and C1 and make D1
For example 6 and 12 and 2024 into 6/12/2024
thanks
If you want the result as a text string, enter the following formula in D1:
=TEXTJOIN("/", TRUE, A1:C1)
If you want the result as a date, format D1 as a date and enter the formula:
=DATE(C1, A1, B1)
1 Reply
If you want the result as a text string, enter the following formula in D1:
=TEXTJOIN("/", TRUE, A1:C1)
If you want the result as a date, format D1 as a date and enter the formula:
=DATE(C1, A1, B1)