+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 16 of 16

Calculate interest between two dates with varying interest rates during the period

  1. #16
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    2,945

    Re: Calculate interest between two dates with varying interest rates during the period

    Hi @magi41


    The formula did not take into account whether the year was leap year or not. I used @ tim201110's strategy to fix it.
    =SUMPRODUCT(($M$3:$M$12-$L$3:$L$12+1-($B25>$L$3:$L$12)*($B25<=$M$3:$M$12)*($B25+1-$L$3:$L$12))*$P$3:$P$12
    /(365-28+DAY(DATE(YEAR(B25),3,0)))*E26)

    See the file
    Attached Files Attached Files

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1