Processing Time (Days)

Hello-

Can you help me with my formula? Processing time is "0" should be 1 day.

Thanks.

=IFERROR(IF(NOT(ISBLANK([Date Recorded Quote]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Quote]@row), IF(NOT(ISBLANK([Date Recorded CE Leads]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded CE Leads]@row), IF(NOT(ISBLANK([Date Recorded Pipeline]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded Pipeline]@row), IF(NOT(ISBLANK([Date Recorded for PO Submitted]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for PO Submitted]@row), IF(NOT(ISBLANK([Date Recorded for Others]@row)), NETWORKDAYS([Date Started]@row, [Date Recorded for Others]@row)))))), "")

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Marilen.Navarro103391

What date is in your [Date Started] column? Is it the same (11/26/23)?

Note that the 26th is a Sunday which means it's not a working day. That means if your Start Date is 11/26/23 and your End Date (Date Recorded Quote) is 11/26/23, the Networkdays is 0, since there are no working days present.

Do you mean to use the NETDAYS Function instead, to include Saturdays and Sundays in your count?

Genevieve P.

Haha no problem at all! 🙂 Here you go:

https://media.giphy.com/media/l1IY8onMgFEotIzew/giphy.gif

All comments

Genevieve P.

Hi @Marilen.Navarro103391

What date is in your [Date Started] column? Is it the same (11/26/23)?

Do you mean to use the NETDAYS Function instead, to include Saturdays and Sundays in your count?

Marilen.Navarro103391

@Genevieve P. Thanks. I should drink coffee first. :)

Genevieve P.

Haha no problem at all! 🙂 Here you go:

https://media.giphy.com/media/l1IY8onMgFEotIzew/giphy.gif

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.