Incorrect result for NETDAYS and NETWORKDAYS formulas

Hi everyone - would appreciate any help with this. I am trying to calculate both the net days as well as working days between today and a start date. My formulas are working....kind of. I'm not getting an error, but the results are incorrect (per other countdown sites and google). So if I should get 203 days I'm getting 211 for the NETDAYS, and instead of 137 I'm getting 143 for NETWORKDAYS.

My formulas are below. I've also tried the more simple NETDAYS(TODAY(), StartDate) etc. Both give the same incorrect result.

=IF(DATEONLY(TODAY()) = Date2, 0, NETDAYS(TODAY(), Date2) + " days")

=IF(DATEONLY(TODAY()) = Date2, 0, NETWORKDAYS(TODAY(), Date2, Date20:Date29)) + " working days"

Any help appreciated!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots of the data?

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.