... ACCRINTM(issue,maturity,rate[,par,basis]) . ACCRINTM calculates and returns the accrued interest for a security from @issue to @maturity date. @issue is the issue date of the security. @maturity is the maturity date of the security. @rate is the annual rate of the security and @par is the par value of the security. ... If @issue date or @maturity date is not valid, ACCRINTM returns #NUM! error. ... If @issue date is after @maturity date or they are the same, ACCRINTM returns #NUM! error. ...