I am attempting to create a named range for a graph to display data
from the end of each month. Ideally, the data for the range would come
from the following set:

A Jan Feb Mar Apr
B g2 g8 g12 #N/A

where each cell in row B contains a cell reference for the date of the
last workday of a month. For months that have not occured yet, the
formula I created returns the #N/A error. My problem is creating the
named range that uses the INDIRECT() function to read in each cell
reference that exists.

The data needs to remain a cell reference (instead of the value it is
referring to) so that I can later use an OFFSET() function on the named
range to grab the performance values for each month.

Any comments or suggestions would be greatly appreciated.