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

Did this answer your question?