Array Transformation functions

FISCAL_QUARTERS_MARCH

Reference

» N/A

About

Determines from Month End Dates, Fiscal Quarters (for a Business Organisation whose Fiscal Year ends at the end of March).

Inputs:

  • month_end_dates_array : array of month end dates

Code

M.S. Excel 
FISCAL_QUARTERS_MARCH = LAMBDA(month_end_dates_array,
    LET(
        Calendar_Month, month_end_dates_array,
        Fiscal_Month, IF(
            MONTH(Calendar_Month) - 3 > 0,
            MONTH(Calendar_Month) - 3,
            MONTH(Calendar_Month) + 9
        ),
        Fiscal_Quarter, "Q" & QUOTIENT(Fiscal_Month + 2, 3),
        Fiscal_Quarter
    )
);