Skip blank cells in a workingdays formula
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!!