Days Remaining until Due Date (minus weekends)

Caryn

I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only.

My original formula was:

The formula I thought would work was this, but got a #invalid data type error:

Any suggestions? Thank you!

Find more posts tagged with

Sheets

Formulas

Accepted answers

Nick Korna

Hi @Caryn ,

The NETWORKDAYS formula is slightly different than how you're trying to use it:

So in this case you would want the section of the formula dealing with this to be:

NETWORKDAYS(TODAY(),[Date Due]@row)

If there are any extra holiday days, you can add these in a column (on another sheet if necessary) and then put to have the section of the formula more like this (using a column called "Holidays" in this example):

NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)

Hope this is of assistance!

All comments

Nick Korna

Hi @Caryn ,

The NETWORKDAYS formula is slightly different than how you're trying to use it:

So in this case you would want the section of the formula dealing with this to be:

NETWORKDAYS(TODAY(),[Date Due]@row)

NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)

Hope this is of assistance!

Caryn

Thank you very much! It worked:

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.