Description
The FINANCIALPERIOD function returns the matching financial period for a given year and period number.
Syntax
FINANCIALPERIOD(Connection, Year, PeriodNumber)
Parameters
The FINANCIALPERIOD function uses the following parameters (see our articles on including multiple parameter values and using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Year | Required | The year of the financial period. |
PeriodNumber | Required | The period number. A value that is lower or higher than the number of periods in the current year will yield a period that is in a different financial year. |
Example
The following examples assume a financial year with 12 periods.
Function | Result |
=FINANCIALPERIOD("Demo", "2017", 2) | 02-2017 |
=FINANCIALPERIOD("Demo", "2017", 1) | 01-2017 |
=FINANCIALPERIOD("Demo", "2017", 0) | 12-2016 |
=FINANCIALPERIOD("Demo", "2017", -1) | 11-2016 |
=FINANCIALPERIOD("Demo", "2017", 13) | 01-2018 |
=FINANCIALPERIOD("Demo", "2017", 14) | 02-2018 |
Applies to
GL Module