Difference between revisions of "Manuals/calci/YEARBASIS"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
*<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>Basis</math> value is optional. If omitted, Calci assumes it to be 0. | *<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0. | ||
| + | *We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]". | ||
Below table shows the use of <math>Basis</math> values: | Below table shows the use of <math>Basis</math> values: | ||
| Line 67: | Line 68: | ||
=YEARBASIS(DATE(2014,1,1)) : Calculates the number of days in the year for the specified date. Here basis count is omitted. <br/> Returns '''360''' 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. <br/> Returns '''360''' as a result. | ||
| + | =YEARBASIS("21/10/2042[DD/MM/YYYY]") =360 | ||
==Related Videos== | ==Related Videos== | ||
Revision as of 15:05, 22 May 2018
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.
- We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
Below table shows the use of 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. =YEARBASIS("21/10/2042[DD/MM/YYYY]") =360
Related Videos
See Also
References