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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!