nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

NETWORKDAYS

Sarah T

I'm dying over here! I have tried this formula countless times and #unparesable keeps populating.

I am trying to calculate thew amount of days between 2 dates. My column name is Date and Date Complete.

I created another Column titled Days to Complete.

This is my formula.

NETWORKDAYS([Date], [Date Complete], [holidays])

What am I doing wrong??????

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try this:

=NETWORKDAYS(Date@row, [Date Complete]@row)

LeelaLodhi03

Sarah T

Hi Paul! Thanks for answering. Its still showing #unparseable

Paul Newcome

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it as well as the column headers of the columns being referenced?

LeelaLodhi03

Hi @Sarah T,

You’re very close—this is just a syntax issue.

Your formula needs to start with = and include @row references.

If you also have a list of holidays, you can include those as well—but you’ll need to create a cross-sheet reference (you can’t just type [holidays]). Once referenced, your formula will look like:

=NETWORKDAYS([Date]@row, [Date Complete]@row, {Holidays})

Sarah T

I am!

Sarah T

When I try that (minus the holiday part), it says # invalid data type

heyjay

What column type do you have for this column Days to complete? This should be text/number .

Can you also confirm that the columns Date and Date Complete are Dates in the column properties?

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.