Counting only weekdays Formula?

Hello,

I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current to capture the amount of days it has been open. Also while I need it to count the amount of days its been open i need it to stop counting if the date closed is there.

Formula; =IF(Status@row = "Closed", [Date Closed]@row - [Date Opened]@row, TODAY() - [Date Opened]@row)

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Dakota Haeffner

I think you will need to use NETWORKDAYS in your formula.

Jeremy Oesch

Hi Maybe I am not understanding the NETWORKDAYS formula but while i understand the formula as a whole how do i make it so its every weekend. I see that i can put holidays but do i have to list every weekend? Tickets can be places when every so how would i have it exclude every weekend?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.