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