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 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