Ageing Calculation

[sur]

Hello Team,

Need to calculate the aging in excel for the multiple products.

below the screenshot, i am looking for formula to derive the Result and Ageing Days:

 

[Cubist]

Which version of Excel are you using?
Try:

Book1
	A	B	C	D	E	F
1	Aging Days	Result	Inflow	Outflow	Report Date	Product
2	-	5/9/2024	Yes	No	5/9/2024	A
3	-	5/9/2024	No	No	5/10/2024	A
4	-	5/9/2024	No	No	5/13/2024	A
5	5	5/9/2024	No	Yes	5/14/2024	A
6	-	5/15/2024	Yes	No	5/15/2024	A
7	-	5/15/2024	No	No	5/16/2024	A
8	-	5/15/2024	No	No	5/17/2024	A
9	-	5/15/2024	No	No	5/20/2024	A
10	6	5/15/2024	No	Yes	5/21/2024	A
Sheet3

Cell Formulas
Range	Formula
A2:A10	A2	=IF(AND(C2="No",D2="Yes"),E2-B2,"-")
B2:B10	B2	=LOOKUP(2,1/($C$2:C2="Yes"),$E$2:E2)