Difference between revisions of "Manuals/calci/TOQUARTER"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
*This function is showing the quarter of the given numbers. | *This function is showing the quarter of the given numbers. | ||
*In <math>TOQUARTER(QuaterIndex)</math>,<math>QuaterIndex</math> are the numbers of the month. | *In <math>TOQUARTER(QuaterIndex)</math>,<math>QuaterIndex</math> are the numbers of the month. | ||
| − | *There are four | + | *There are four quarter values. |
*A three-month period on a financial calendar that acts as a basis for the reporting of earnings. | *A three-month period on a financial calendar that acts as a basis for the reporting of earnings. | ||
*A quarter refers to one-fourth of a year and is typically expressed as "Q." | *A quarter refers to one-fourth of a year and is typically expressed as "Q." | ||
Revision as of 13:57, 3 December 2018
TOQUARTER (QuarterIndex)
- is the month number.
is the month number.Description
- This function is showing the quarter of the given numbers.
- In , are the numbers of the month.
- There are four quarter values.
- A three-month period on a financial calendar that acts as a basis for the reporting of earnings.
- A quarter refers to one-fourth of a year and is typically expressed as "Q."
- The four quarters that make up the year are
,
are the numbers of the month.Quarter 1:January,February and March. Quarter 2:April,May and June Quarter 3: July,August and September Quarter 4:October,November and December.
Examples
- TOQUARTER(4) = Q2
- TOQUARTER(10) = Q4
- TOQUARTER([3,6,9,11]) = Q1 Q2 Q3 Q4