Looking for logical date formula

[spycein]

Hi Every one,
I have a following data of Fixed Deposit

Principal Amount	Interest Rate %	FD Start Date	FD Maturity Date	No. of Days	Maturity Amount	Total Interest Earned
1,000.00	5.00%​	29-Oct-18​	29-Jan-19​	92​	1,013.00	13.00
2,000.00	6.00%​	03-Jan-19​	08-Apr-19​	95​	2,031.00	31.00
3,000.00	6.00%​	03-Jan-19​	08-Apr-19​	95​	3,047.00	47.00
4,000.00	5.00%​	29-Jan-19​	01-May-19​	92​	4,050.00	50.00
5,000.00	6.00%​	08-Apr-19​	09-Jul-19​	92​	5,076.00	76.00
6,000.00	6.00%​	01-May-19​	01-Aug-19​	92​	6,091.00	91.00

I am looking for a excel formula which would return the interest amount for a specific period.
For example if i provide a date range as start date 01/01/2019 and end date 31/01/2019 then the formula should return the interest amount for the period only.
Thanks in Advance.
Best Regards,

 

[StuLux]

This is what your last column is already doing i.e. for the first line the interest rate is 5% (which for a whole year would be 50) - the period is 92 days so the interest would be (50/365) X 92 so the formula for 7th column could be (assuming the table starts in Cell A1):

=A2*B2/365*E2