hi, i want to calculate the weighted average maturity of a list of contracts as at a certain date for multiple dates.
In col A, i have the day the contract started, colum b the maturity in years, and column c the amount of the contract. I want to calulcate month end weighted average maturities. Notmally i would sumproduct columns b and c and devide by the sum of C. But the condition of the date is confusing me. What is the best formula to use?
In col A, i have the day the contract started, colum b the maturity in years, and column c the amount of the contract. I want to calulcate month end weighted average maturities. Notmally i would sumproduct columns b and c and devide by the sum of C. But the condition of the date is confusing me. What is the best formula to use?