Forum Discussion
Solved
Help with concatenate with IF function for blank date
I am using Concatenate (CONCAT) to pull 3 date values from a worksheet within a workbook. =CONCAT(TEXT(('Liability Schedule'!F219),"mm/dd/yyyy"),"
",
TEXT(('Liability Schedule'!F220),"mm/dd/yyyy"),...
=CONCAT(TEXT(IF('Liability Schedule'!F219,'Liability Schedule'!F219,"NA"),"mm/dd/yyyy"),"
",
TEXT(IF('Liability Schedule'!F220,'Liability Schedule'!F220,"NA"),"mm/dd/yyyy"),"
",
TEXT(IF('Liability Schedule'!F221,'Liability Schedule'!F221,"NA"),"mm/dd/yyyy"))Does this work in your sheet as well?
=CONCAT(TEXT(IF('Liability Schedule'!F219,'Liability Schedule'!F219,"NA"),"mm/dd/yyyy"),"
",
TEXT(IF('Liability Schedule'!F220,'Liability Schedule'!F220,"NA"),"mm/dd/yyyy"),"
",
TEXT(IF('Liability Schedule'!F221,'Liability Schedule'!F221,"NA"),"mm/dd/yyyy"))
Does this work in your sheet as well?