Combining multiple NETDAYS but some are blank

Options

Hi. I have a formula that works but only if there are no blank cells. I want it to work while some of the date cells are empty. This formula is intended to keep track of equipment rentals. Sometimes only one person rents equipment and sometimes multiple people rent equipment for short periods of time, but I have to make sure the equipment doesn't stay out for longer than a certain number of total days.

=IFERROR(SUM(NETDAYS(Start@row, End@row), NETDAYS([Start 2]@row, [End 2]@row), NETDAYS([Start 3]@row, [End 3]@row)), "")


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!