Difference between revisions of "Manuals/calci/YEARBASIS"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
*YEARBASIS() returns the number of days in the year for the mentioned date with respect to basis count. | *YEARBASIS() returns the number of days in the year for the mentioned date with respect to basis count. | ||
*<math>Date</math> should be entered either in 'date format' or 'date returned using formula'. If date is not valid, Calci displays #N/A error message. | *<math>Date</math> should be entered either in 'date format' or 'date returned using formula'. If date is not valid, Calci displays #N/A error message. | ||
| − | *<math> | + | *<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0. |
Below table shows the use of <math>basis</math> values: | Below table shows the use of <math>basis</math> values: | ||
| Line 31: | Line 31: | ||
|} | |} | ||
| − | *If <math> | + | *If <math>Basis</math> value is other than 0 to 4, Calci displays #N/A error message. |
== Examples == | == Examples == | ||
Revision as of 05:02, 18 March 2017
YEARBASIS(Date, Basis)
where
- represents a start date, and
- is the type of day count basis to use.
represents a start date, and
is the type of day count basis to use.YEARBASIS() calculates the number of days in the year for the mentioned date with respect to basis count.
Description
YEARBASIS(Date, Basis)
- YEARBASIS() returns the number of days in the year for the mentioned date with respect to basis count.
- should be entered either in 'date format' or 'date returned using formula'. If date is not valid, Calci displays #N/A error message.
- value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of values:
values:
| Basis | Description |
|---|---|
| 0 | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
- If value is other than 0 to 4, Calci displays #N/A error message.
Examples
YEARBASIS(Date, Basis) function with inputs in order is calculated as follows:
| 1/4/2008 | |
| 10/10/2008 | |
| 4 |
=YEARBASIS(A1,A3) : Calculates the number of days in the year for cell A1 for basis count 4. Returns 360 as a result.
=YEARBASIS(A2,A3) : Calculates the number of days in the year for cell A2 for basis count 4. Returns 360 as a result.
=YEARBASIS(DATE(2014,1,1),0) : Calculates the number of days in the year for the specified date for basis count 0.
Returns 360 as a result.
=YEARBASIS(DATE(2014,1,1),1) : Calculates the number of days in the year for the specified date for basis count 1.
Returns 365 as a result.
=YEARBASIS(DATE(2014,1,1),2) : Calculates the number of days in the year for the specified date for basis count 2.
Returns 360 as a result.
=YEARBASIS(DATE(2014,1,1),3) : Calculates the number of days in the year for the specified date for basis count 3.
Returns 365 as a result.
=YEARBASIS(DATE(2014,1,1)) : Calculates the number of days in the year for the specified date. Here basis count is omitted.
Returns 360 as a result.
Related Videos
See Also
References