The formula for calculating interest is as follows:
Invested amount * Amount of days * Interest rate / 365.
Interest is calculated for all investment period. For example: 1000*30*0.14/365=11.51 EUR.
For counting days of investment, the formula DAYS is used: =DAYS (end_date, start_date).