Aging Date Reporting

SConsulting

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))

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.