Forum Discussion
Solved
using TEXTJOIN
Can somebody please point out what I'm doing wrong? Im trying to use the join text function but there is a date involved. Every time I add the cell that contains the date, it wants to list it as "432...
Hi Ronda,
Dates in Excel are actually numbers. Use instead TEXT(A1,"mm/dd/yyyy") if A1 is your date
Hi Ronda,
Dates in Excel are actually numbers. Use instead TEXT(A1,"mm/dd/yyyy") if A1 is your date
D2 "mm/dd/yyyy" this tells me invalid