Aging Date Reporting

I used this formula for reporting aging days from a specific date (8/1/2022) with the range the date the item was created. I need to report aging from "current date" to the create date. Is there a way for the system to automatically calculate from the current date?

=COUNTIFS({TJ Regional Health eService Range 6}, =DATE(2022, 8, 1))

Find more posts tagged with

Accepted answers

All comments

Jason Tarpinian

You can use NETDAYS (calendar days) or NETWORKDAYS (M-F, or whatever you have in your project settings).

=NETDAYS(DATE(2022, 8, 1), TODAY())

=NETWORKDAYS(DATE(2022, 8, 1), TODAY())

SConsulting

Thank you.

Since the create date changes, is there a way to put the create date series where we have 2202, 8, 1 for the date?

SConsulting

Tried this formula which is not working.

=NETWORKDAYS(DATE(Created@row1, TODAY()))

Paul Newcome

@SConsulting Try removing the 1 from after @row, switching over to a DATEONLY function an dcorrecting a misplaced parenthesis:

=NETWORKDAYS(DATEONLY(Created@row), TODAY())

SConsulting

Thank you so much. I will plug this in and get it testing.

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.