Forum Discussion
Solved
Aging Report
Good Afternoon! I'm aging sales data but need it to stop aging when an item is sold. I have start date(G5) sale date (H5) and days aged as of today columns. This is my formula but it's not working. I...
There are other ways to do it, but I will keep your approach as adjusted below
=IF(H5<1,TODAY()-G5,DATEDIF(G5,H5,"d"))
Nice! Thanks. Something simpler?
