Calc EOQUARTER function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The EOQUARTER function helps you find the last day of the quarter for a date that's a certain number of quarters away from a starting date. This can be useful for financial calculations, reporting periods, or any scenario where you need to determine the end of a fiscal quarter.

Syntax

EOQUARTER(date)

The EOQUARTER function syntax has the following arguments:

• date Required. Dates should be entered either by using the "YYYY-MM-DD" format or by using the DATE function, or as results of other formulas or functions.

Remarks

• The function calculates the last day of the quarter for the date that is 'quarters' away from 'start_date'.
  • For example, EOQUARTER(DATE(2020, 1, 15), 1) gives you March 31, 2020, since that's the last day of the first quarter after January 15, 2020.
  • EOQUARTER(DATE(2020, 1, 15), -1) gives you December 31, 2019, which is the last day of the fourth quarter before January 2020.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc DATE function
• Calc DATEDIF function
• Calc DATESUB function
• Calc DAY function
• Calc DAYS function