Calculation within IF statement
I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise compute the variance:
=IF(ISBLANK([Completion Date]@row), "", =NETDAYS([Request Date]@row, [Completion Date]@row))
This returns "#INVALID OPERATION" on the whole column. I've tried the =IF(NOT(ISBLANK variation with the same result. Is there a way to include formulas within an IF statement? Or is there a different way to accomplish my goal here?
Thanks for you assistence!
Help Article Resources
Check out the Formula Handbook template!