Forum Discussion

SARAWALL007's avatar
SARAWALL007
Copper Contributor
Oct 31, 2021
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...
Formulas and Functions
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Oct 31, 2021

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

     

Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Oct 31, 2021

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

 

SARAWALL007's avatar
SARAWALL007
Copper Contributor
Oct 31, 2021
Nice! Thanks. Something simpler?
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 31, 2021

    SARAWALL007 

    Perhaps

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