I have two columns settlement date and maturity date. I am trying to calcukate the number of days interest is charged in a given month. For example if a security is settled on Jan 5th and maturing on February 10th, the number of days interest is charged in Jan is 26 days (1/5 to 1/31). I I have attached the file for example.
Bookmarks