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.

ParameterDescription
YearThe year that you want the period name for.
PeriodThe period number that you want the period name for.
LedgerOptionally 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.
OffsetOptionally 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.

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

Attachments: