R
Rachel
I need to figure out the Weighted Average Remaining to Maturity for Certificates of Deposit
I need to use one cell, which has a date (our quarter end), one cell that has the next maturity date of the CD, multiplied by 360 days in a year, all divided by 30 days in a month.
What formula would I use? I can figure weighted average for a range of cells, but not for when only one cell is involved.
I need to use one cell, which has a date (our quarter end), one cell that has the next maturity date of the CD, multiplied by 360 days in a year, all divided by 30 days in a month.
What formula would I use? I can figure weighted average for a range of cells, but not for when only one cell is involved.