How can I change this Formula to leave the cell blank rather than #INVALID DATE?

Most of the other columns in my sheet only require the counting of days from a date in a different column. When the source column in the formula is not filled out the cell is blank. I am guessing it has something to do with it starting as "IFERROR".

EXAMPLE OF A FORMULA THAT WORKS:

=IFERROR(WORKDAY([Bldg Initial Submittal]@row, +5, Holidays:Holidays), "")

I have since needed to have a date calculated by adding multiple different values together rather than just counting from a singular date. This formula works when each of those columns have values entered, but when one is blank the Column it is applied to says "INVALID DATE" since it is missing part of the equation.

EXAMPLE OF THE FORMULA PRODUCING #INVALID ERROR:

=WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays)

How can I edit the above formula to leave a cell blank when information is missing?

P.S I have tried doing and got an error:

=IFERROR(WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays), "")

Best Answer

Answers