Array Transformation functions

FISCAL_YEARS_MARCH

Reference

» N/A

About

Determines from Month End Dates, Fiscal Years (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_YEARS_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_Year, IF(Fiscal_Month <= 9, YEAR(Calendar_Month) + 1, YEAR(Calendar_Month)),
        Fiscal_Year
    )
);