Forum Discussion
RPINEDA2
Feb 09, 2024Copper Contributor
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...
- Feb 09, 2024
=IF(B2="Invoice",LOOKUP(2,1/("Payment"=$B$2:B2),$C$2:C2)-C2,"")
This formula returns the expected results in my sheet.
OliverScheurich
Feb 09, 2024Gold Contributor
=IF(B2="Invoice",LOOKUP(2,1/("Payment"=$B$2:B2),$C$2:C2)-C2,"")
This formula returns the expected results in my sheet.
RPINEDA2
Feb 09, 2024Copper Contributor
You have saved me from a lot of manual work. Thank you!