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))
Answers
-
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())
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
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?
-
Tried this formula which is not working.
=NETWORKDAYS(DATE(Created@row1, TODAY()))
-
@SConsulting Try removing the 1 from after @row, switching over to a DATEONLY function an dcorrecting a misplaced parenthesis:
=NETWORKDAYS(DATEONLY(Created@row), TODAY())
-
Thank you so much. I will plug this in and get it testing.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!