ACCRINT(issue, first_interest, settlement, rate, par ,frequency [,basis] [,calc_method]) 
Returns the accrued interest for a security that pays interest periodically. 
issue  The date the security is issued. 
first_interest  The date when the initial interest is paid. 
settlement  The settlement date of the security. 
rate  The annual interest rate or coupon when the security was issued. 
par  The par value of the security. 
frequency  The number of coupon payments per year: 1 = annual 2 = semi annual (default) 4 = quarterly 
basis  (Optional) The type of day counting to use: 0 = US 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/360 
calc_method  (Optional) The start date for the accrued interest: True = start accruing interest from the issue date. False = start accruing interest from the last coupon payment date. 
* Dates must be entered as text strings within quotation marks or as serial numbers.
* The "issue" date and the "first_interest" date are needed to calculate the amount accrued each day.
* If "issue" is not an integer, it is truncated.
* If "issue" is not a valid date, then #VALUE! is returned.
* If "issue" >= "settlement", then #NUM! is returned.
* If "first_interest" is not an integer, it is truncated.
* If "first_interest" is not a valid date, then #VALUE! is returned.
* The "settlement" date when the security is traded to the buyer.
* If "settlement" < "issue", then
* If "settlement" is not an integer, it is truncated.
* If "settlement" is not a valid date, then #VALUE! is returned.
* If "rate" <= 0, then #NUM! is returned.
* If "par" is left blank, then 1000 is used.
* If "par" <= 0, then #NUM! is returned.
* If "frequency" is left blank, then 2 is used.
* If "frequency" is not an integer, it is truncated.
* If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* You can use the DATE function to enter your dates.
* In Excel 2007 the "calc_method" was added.
* The "par" argument was optional in Excel 2003 but required in 2007.
* The "frequency" was optional in Excel 2003 but required in 2007.
* For the Microsoft documentation refer to support.office.com
* In Excel 2003 this function was only available when you had the Analysis ToolPak addin loaded.

1  How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 Apr 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 Apr 2011 with a coupon of 6% paid semiannually with a day count of 30/360.
2  How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 May 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 May 2011 with a coupon of 6% paid semiannually with a day count of 30/360.
3  How much interest has accrued on a US treasury bond between 1 Mar 2011 and 1 Sep 2011. The bond has a par value of $1,000 issued on 1 Mar 2011 with a first interest paid date of 1 Sep 2011 and a settlement date of 1 Sep 2011 with a coupon of 6% paid semiannually with a day count of 30/360.
4  The same as Example but with a day count of Actual/Actual.
13  If "basis" is very large thern #NUM is returned.
© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited