Skip blank cells in a workingdays formula

Hello,

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!!

Find more posts tagged with

Accepted answers

All comments

Leibel S

@Tbech

Try the below:

=IF(AND([MPT Start Date]@row<>"",[MPT Due Date]@row<>""),NETWORKDAYS([MPT Start Date]@row, [MPT Due Date]@row),"")

This will leave it blank (not a 0) if you are not using the process.

Probably better to do it this way if you plan averaging the column...

Tbech

Thanks so very much!!!!

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.