Aging Report

[SARAWALL007]

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

[#2 · Accepted solution]

@SARAWALL007 

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]

Nice! Thanks. Something simpler?

[#4]

@SARAWALL007 

Perhaps

=IF( H5, H5, TODAY() ) - G5