There are fifteen calendar functions for average, sum, and value calculations, which cover five fixed time periods: week; month; quarter; half year; year. They are:
Calendar quarterly value (CFQ#)
Calender half year value (CFH#)
Calendar quarter average (CQA#)
Calender half year average (CHA#)
Values are given for complete periods only. Any incomplete periods between the start and end dates you specify are ignored. For example, calendar month average (CMA#) calculates data for complete calendar months. If you specify a start date of the 15th of the month, values from the 15th to the last day of that month are ignored and the effective start date is the 1st of the following month.