Formula Help Error Message NETWORKDAYS

Carol Bokas

New user of SmartSheet and not too adept at Excel. I am trying to make a formula IF/AND so that there is no error message in a cell that uses the NETWORKDAYS functions if there are not dates in the two source columns. E.g., Job Complete-Est and Job Complete-Actual only have a date in neither or one 

So, if there is not a date in either, the cell with the variance will be blank rather than #Missing or invalid parameters

John Deurbrouck

This will do it:

 

=IF(AND(ISDATE([Job Complete-Est]1), ISDATE([Job Complete-Actual]1)), NETWORKDAYS([Job Complete-Actual]1, [Job Complete-Est]1), "")

 

This will display an empty cell if either of the date columns is empty, but will show the calculation if both are dates.

 

John