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 keep getting an excel error. I'm trying to tell it if there is no date in H5, use today's date. Each formula works independently. Any ideas?
=DATEDIF(G5,H5,"d"),IF(H5<1(TODAY()-G5,0))
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"))
3 Replies
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?
