Manuals/calci/YEARBASIS

YEARBASIS(Date, Basis)

where

• $Date$ represents a start date, and
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} 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.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Date} should be entered either in 'date format' or 'date returned using formula'. If date is not valid, Calci displays #N/A error message.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} values:

Basis	Description
0	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

• If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis} 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

YEARFRAC

See Also

• YEAR

References

• Date Formats
• Calendar Year
• Basis Convention

• List of Main Z Functions

• Z3 home