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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!