Forum Discussion
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"),"
",
TEXT(('Liability Schedule'!F221),"mm/dd/yyyy"))However, if the Liability Schedule doesn't have a value (blank), excel will default to 01/00/1900. I'm trying to expand the rule that IF the referring cell is blank in the Liability Schedule, I want to replace it with "N/A"
=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?
