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”

​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”  Read More

​