ACCRINTM calculates and returns the accrued interest for a security from @issue to @maturity date. @rate is the annual rate of the security and @par is the par value of the security. If you omit @par, ACCRINTM applies $1,000 instead. @basis is the type of day counting system you want to use:
0 US 30/360
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360
If @basis is omitted, US 30/360 is applied. If issue date or maturity date is not valid, ACCRINTM returns NUM! error.If @rate or @par is zero or negative, ACCRINTM returns NUM! error.If @basis < 0 or @basis > 4, ACCRINTM returns NUM! error. If issue date is after maturity date or they are the same, ACCRINTM returns NUM! error.