Skip to main content

Returns the period name for the chosen year and period number. Optionally the returned value can be a certain number of periods into the future or past.

Parameter Description
Year The year that you want the period name for.
Period The period number that you want the period name for.
Ledger Optionally enter a Ledger Id to bind the formula to a specific Ledger. If this parameter is omitted, the Ledger currently selected in the Ledger dropdown list will be used.
Offset Optionally enter an offset to return the period name which is n periods before or after the entered criteria e.g. enter 3 to return 3 periods in to the future or enter -1 to return the previous period.
Adjustment Period Optionally set the Adjustment Period parameter to exclude or include adjustment periods. By default all adjustment periods are included.

Example 1: =GLW_Period_Name(2002,1,1,5)

Example 2: =GLW_Period_Name(2002,1,1,5,”False”)

Was this article helpful?

We're sorry to hear that.