Period Name |
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 |
PeriodYear | The year that you want the period name for |
PeriodNumber | The period number that you want the period name for |
Book | Optionally enter a set of books id to bind the formula to a specific set of books. 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 into the future or -1 to return the previous period. |
Example =Period_Name(2006,3)