ACCRINT(issue,first_interest,settlement,rate,par,frequency[,basis])
ACCRINT calculates the accrued interest for a security that pays periodic interest.
issue is the issue date of the security. first_interest is the first interest date of the security. settlement is the settlement date of the security. The settlement date is always after the issue date (the date when the security is bought). rate is the annual rate of the security and par is the par value of the security. frequency is the number of coupon payments per year.
Allowed frequencies are:
1 = annual,
2 = semi,
4 = quarterly.
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