Difference between revisions of "Manuals/calci/TOQUARTER"

 
(One intermediate revision by the same user not shown)
Line 19: Line 19:
 
#TOQUARTER([3,6,9,11])  
 
#TOQUARTER([3,6,9,11])  
 
   QuarterIndex  TOQUARTER
 
   QuarterIndex  TOQUARTER
   3                 Q1
+
   3                 Q1
   6                 Q2
+
   6             Q2
   9                   Q3
+
   9                 Q3
   11                   Q4
+
   11                 Q4
  
 
==Related Videos==
 
==Related Videos==

Latest revision as of 06: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