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
Check out the Formula Handbook template!