If you are an expert in excel, please solve my problem.
I have an excel sheet including loans given to many customers. Repayments should be done daily for these loans. Interest rate is 5% per month (30 days). If loans have been given in previous dates, How to find the total interest payable up to a current date. Can you tell me a formula?