Skip blank cells in a workingdays formula

Hello,

I am currently using this formula to calculate number of working days. On the same sheet, I have two different processes that I track. Some assets on rows do not complete both processes so there are blank cells.

=NETWORKDAYS([MPT Start Date]@row, [MPT Due Date]@row)

How do I tell the formula if the start and end date are blank, insert a 0 in the column.

I will be adding a widget to my dashboard that will average this column and I believe the error messages I currently see will prevent me from asking the column to provide an aver number of working days.


Can you assist me with this please? Thank you!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!