Difference between revisions of "Manuals/calci/TOQUARTER"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 20: Line 20:
 
   QuarterIndex  TOQUARTER
 
   QuarterIndex  TOQUARTER
 
   3                Q1
 
   3                Q1
   6             Q2
+
   6             Q2
 
   9                Q3
 
   9                Q3
 
   11                Q4
 
   11                Q4

Latest revision as of 05:22, 26 May 2020

TOQUARTER (QuarterIndex)


  • 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
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

  1. TOQUARTER(4) = Q2
  2. TOQUARTER(10) = Q4
  3. TOQUARTER([3,6,9,11])
 QuarterIndex  	TOQUARTER
  3                 Q1
  6	            Q2
  9                 Q3
 11                 Q4

Related Videos

Quarter

See Also

References