Forum Discussion
Excel in Office 365 Copy information
I have Column 3 (Baptism) with dates. I have Column 4 (Letters) with dates. I have Column 6 (Statements) with dates. I have Column 8 that I want to "Copy" the dates from each column (3,4,6) to colum...
CindyLackey Since you mention that you are using MS365, the TEXTJOIN function will smoothly combine the three dates into a string of three "numbers" that you could then sort. And if you do that in a structured table, the formula will copy itself down when you add more data later on.
But I wonder why you would want to do that at all. If you have three date columns that you want to sort on, you can use a custom sort. First by Baptism, then by Letters, then by Statements. No formulae needed.