Friends
Everyone has saving bank account in bank, but lot of persons do not check their interest credit in saving bank pass book. Recently , Reserve Bank of India has issued notification that the interest on saving account will be given on daily product basis w.e.f. 01.04.2010. To calculate interest in a minute and comparison of interest amount with present and w.e.f. 01.04.2010, the following calculator will be helpful for you.
A example is given in calculator and you can change rate of interest and debit and credit amount as per your need. Only white cell is available to enter data. Other fields are locked due to formulas. Month wise interest can be checked through this excel utility. You can also change maximum days in a month.
If you have opening balance then you can use Debit or Credit Column of 1 st column (Day(Date)) in above calculator
In this way if days are less than in a month from 31, you can use debit or credit balance for setting zero balance for 31 day.