Forum Discussion

RPINEDA2's avatar
RPINEDA2
Copper Contributor
Feb 09, 2024

Aging

Hi,   I would like to have an aging on column D.    For the below data I need to add the aging in column D for every invoice. This aging is in relation to the payment date that appears first abov...
  • OliverScheurich's avatar
    Feb 09, 2024

    RPINEDA2 

    =IF(B2="Invoice",LOOKUP(2,1/("Payment"=$B$2:B2),$C$2:C2)-C2,"")

    This formula returns the expected results in my sheet.

Resources