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

Find more posts tagged with

Accepted answers

All comments

Ipshita

Hi @RossG you need to add =IF(ISBLANK to your formula so it looks up the blank cells and still returns your desired results. Try using ISBLANK and let me know if it works!

Cheers!

RossG

I can't figure out how that would work in this context.

RossG

I'm just using a workaround for now. Making 3 NETDAYS columns and a SUM column of them separately since I can't figure this out. Just not ideal since I have 3 extra columns now

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.