Combining multiple NETDAYS but some are blank


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)), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!