Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial > COUPDAYS
 

COUPDAYS(settlement, maturity, frequency [,basis])

 
 Returns the number of days in the coupon period that contains the settled date to the next coupon ??

 settlementThe settlement date of the security.
 maturityThe maturity of the security.
 frequencyThe number of coupon payments in a year:
1 = annual
2 = semi annual
4 = quarterly
 basisThe type of day counting to use:
0 = US 30/360
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The settlement date is the date a buyer purchases a coupon, such as a bond.
     
  		• The maturity date is the date when the security expires.
     
  		• If any of the arguments are not integers, they are truncated.
     
  		• If "settlement" >= "maturity", then #NUM! is returned.
     
  		• If "settlement" is not a valid date, then #NUM! is returned.
     
  		• If "maturity" is not a valid date, then #NUM! is returned.
     
  		• If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
     
  		• If "basis" < 0, then #NUM! is returned.
     
  		• If "basis" > 4, then #NUM! is returned.
     
  		• If "basis" is left blank, then 0 is used.
     
  		• What if the "maturity" date has passed ??

     EXAMPLES
     
     A
    1=COUPDAYS("25/1/2007","15/11/2008",2,1) = 181
    2=COUPDAYS("1/25/1998","11/15/1999",2,1) = #VALUE!
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top