Count days between project start and Go Live

Latreva Washington

Hello,

I am trying to create a 'countdown timer' for my dashboard to tell users how many days remain to project Go Live from whatever the date is. The current formula I am using is:

=NETWORKDAYS([Start Date]1, [Due Date]1,[holidays])

and I am receiving the message #UNPARSEABLE

I am uncertain what I am doing incorrectly.

Find more posts tagged with

Accepted answers

All comments

I have never been able to get it to work with the [holidays] you have to manually put in the dates to exclude holidays or make sure you have holidays in the project settings of your sheet and it will automatically exclude the holidays without putting anything in when you use the NETWORKDAYS formula.

=NETWORKDAYS([Start Date]1, [Due Date]1,DATE(2023,7.4))

Or if you have it set up in project settings you will just need to use

=NETWORKDAYS([Start Date]1, [Due Date]1)

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.