concatenate with date exclude empty cells

[rjmdc]

i tried to lock my sheet while still allowing the user to enter rows
so i expanded my table to add another 1000 rows

all the formulas allowed an ifna and returned a blank cell instead
the concatenated formula =(CONCATENATE(TEXT(C3,"mm/dd/yyyy"),B3,E3,F3,K3)) returns 1/00/1900
the column with the date returns an isblank as true

 

[jasonb75]

Try

=(CONCATENATE(TEXT(C3,"mm/dd/yyyy;;"),B3,E3,F3,K3))

 

[rjmdc]

itried this instead
=TEXTJOIN(" ",TRUE,B2,TEXT(C2,"mm/dd/yyyy"),E2,K2)
an still get the 1/00/1900
whats wrong

 

[jasonb75]

still get the 1/00/1900whats wrong

C2 is empty, but TEXT(C","mm/dd/yyyy") is creating the date string before it is checked as empty by TEXTJOIN.

 

[rjmdc]

;; worked
thanks