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. |
Book | Optionally 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. |
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. |
Example: =GLW_Period_Name(2002,1,1,5)