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

 

Carol Bokas

John,

 

Yes, it definitely did it. Thank you for your assistance?

Carol