Formula to calculate time between today and a date in the future.

I need to calculate the work days between my "Requested Customer Date" and today, minus two days. This is the formula I currently have, but it's not calculating correctly.

=NETWORKDAYS([Requested Customer Due Date]@row, TODAY()) - 2

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Can you provide some example dates and outcomes of how it is currently working?

rapach

https://community.smartsheet.com/discussion/comment/304648#Comment_304648

I have the formula in the Project Timeline column

Paul Newcome

They look correct to me. What would be the expected results?

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.