type-conversiongoogle-sheets-formulatextjoincolumnheader

Array formula text join with column header

How to fix this formula, so I can turn the column of dates into text?

=ArrayFormula(UNIQUE((IF(row($A:$A)=1,"DATE LOOKUP",(TEXTJOIN("",TRUE,A1:A))))))

This formula is combining all in one cell - I need each cell to convert in the column not all in one.

enter image description here

=ArrayFormula(UNIQUE((IF(row($A:$A)=1,"DATE LOOKUP",(TEXTJOIN("",TRUE,A1:A))))))

I need to know how to fix this formula so that the results look like this

enter image description here

Solution

  • Try this:

    =ARRAYFORMULA({"Date Lookup";IF(A2:A<>"",TEXT(A2:A,"d-mmm-yyyy"),)})

    Screenshot