You can discover period names in much the same way that you can discover segment values.

1.    Select a cell and enter a valid starting period name e.g. Jan-03 into the cell.

NB – make sure that you enter this starting period name as text by first formatting the Excel cell as text or entering the period name prefixed by an apostrophe ‘ e.g. ‘Jan-03. If Excel interprets the value entered as an actual date e.g. 01/01/2003 then discover period names will not work.

2.    Choose the special “Period” value from the segment list.

3.    Now click the “Discover Down” button.

GL Wand finds the next period name after Jan-07 in the Set of Books calendar and enters this value in the cell below the one that you started in.

You can also use the “Discover Down All”, “Discover Previous”, “Discover Right”, “Discover Right All” and “Discover Left” buttons to discover period names.