Is the end of the year

A relative reference in @if statements used for models in months, quarters, or half years. This function models year end payments of accrued liabilities. Causes no problems in yearly detail.


  • True—if the period is at the end of the fiscal year

  • False—if not


If the model is in quarters and December is the fiscal year end, this formula:


returns 2 in the first three quarters and 1 in the fourth quarter.