Hello,
I have few deposits earning compounded interest quarterly. I have used the formula "=ROUND(FV(E3%/4,G3,,-C3,0),0)" to find out the interest earned between deposit date and Maturity date. However i would like to find out the interest earned for each financial year. (Jan-Dec)
I am herewith attaching the excel sheet. My date format is in "DD-MM-YYYY"
Could any one be kind enough to solve this issue.
Thank you,
Zaska
Bookmarks