Compounded interest between dates

[JohanBvD]

Hi there,

I am trying to calculate the compounded interest between two dates.

Example for a loan given:
Date of the loan given: 17/11/2020
Annual interest amount: 2% p.a. to be charged on a daily basis compounded
End date of loan: 31/01/2021

Thanks

[Richard Buttrey]

Hi and welcome to the forum

A1: Start date: 17/11/2020
A2: Annual Int Rate: 2%
A3: End Date : 31/1/2021

=((1+A2/365)^(A3-A1+1)-1)

Multiply that by the amount of the loan.