Networkdays formula between today and go live date

Hi, I would like a formula to calculate the number of network days between todays date and a go live date and return a negative if go live is in past and positive if go live is in future

eg todays date 24/03/25, (go live date) 29/03/25 = 5 days

Here is the formula im currently using

=TODAY() - [Requested Go-Live]@row

on my formula its showing -5 but would like this to just be 5 days and only show negative for dates in the past.

Thanks

Find more posts tagged with

Formulas

networkdays

Accepted answers

Adam Murphy

Have you tried =NETWORKDAYS(TODAY(), [Requested Go-Live]@row) ? That should work. Hope this helps!

All comments

Adam Murphy

Have you tried =NETWORKDAYS(TODAY(), [Requested Go-Live]@row) ? That should work. Hope this helps!

Karl86

this worked thank you @Adam Murphy

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.