NETDAYS, NETWORKDAYS Function Returning Error

Hello,

I'm trying to calculate the days in between the two dates in the columns below but any formula I use keeps returning an error. Does anyone have any suggestions on how I can fix this?

I've tried simple [Initial Request Date] - [Date of Response] formula and even tried the NETDAYS/NETWORKDAYS nested within IFERROR function and it's still not returning the correct numbers.

Things to know:

"Date of Response" column is a formula converting the Created Date column into date only (using =DATEONLY function)

"Initial Request Date" column contains a formula that takes the Created Date from another sheet based on certain criteria and formatted into date only in that column.

Find more posts tagged with

Accepted answers

All comments

Cory Page

Usually its a format issue but I double checked and it seems to work on my end when I use your descriptions. Can you paste the formula you're using real quick just in case its a typo? Also can you double check that your column properties are set to Date, I am sure they are but it helps rule something out. Thanks,

rmiro

@Cory Page

I tried this formula

I also tried this formula

=NETWORKDAYS([Initial Request Date]@row, [Date of Response]@row)

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.