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.
BookOptionally enter a set of books / ledger id to bind the formula to a specific set of books / ledger. If this parameter is omitted, the set of books currently selected in the Set of Books 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: