If we look at sample dataset 2, we will see that this accrual interest method is different. In Excel, the function ACCRINT looks like the following. =ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Issue: The date when a loan or security is ...