loan calculate day basis

i am new of this forum and i want help.please help me for loan calculate of day basis, i work in a school and require loan account of every teacher's.

Interest calculate of co operative bank of India day basis. i.e. which date loan taken and which month then interst will be counted this date.

exam:- i loan taken 5th September and interst count 5th to 30th september,

ram loan taken 4th february and interst count 4th to 28th february

shyam loan taken 1st january and interst count 1st to 31th january


Actualy this system of my school two type loan given to teachers 1) From Bank :- Mesor Loan, it is maximum period 5 years. 2) from school socity :- shortterm loan :- loan principle amount can fixed by teacher wish, i.e. Rs.500 or Rs2000 and interst count will be date wise.

school have another system: i.e. bank loan interst 12% but socity take 13%, 12% by bank and 1% interst profit of socity



please help and make and excel chart,formula of 10 or more teachers loan list and socity list.
2) day basis loan system, which date loan taken.
3)short term loan ;- day basis which date loan taken and principle cutting of employ's wish


please please dont ignore me