See one answer in microsoft.public.excel.worksheet.functions

Please don't post the same message to multiple groups. It tends to
fragment your answers, and potentially wastes the time of others
answering a question that's already been addressed.


In article ,
Mujeeb ur Rehman, FBL-GRW-PK
m wrote:

PMT() uses 360-Days Bases method to return an annuity or interest. I need
such a formula / function, which calculate interest on 365-Days bases. Can
any body help me in this respect