If you have

=INDEX('Global Input Sheet'!D12:D23,reportperiod)&" "

I'd guess that 'Global Input Sheet'!D12 = "January", D13 ="February"
etc.

reportperiod is presumably a named range (of one cell) that contains a
number 1 to 12. If it can be changed manually then change that to 4 and
you'll get April.

You don't really need a list of the months, you could achieve the same
with

=TEXT(reportperiod*29,"mmmm "), or if you wanted the Month to change
automatically each month

=TEXT(NOW(),"mmmm ")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537567