title: Easier way to spell out Month and Day based on a numeric cell input
body: <p>In the header for one of my spreadsheets I have to type "For the X Months Ended MMMMMM DD, YYYY" where X is the number of the month spelled out in English (I.E. 'Twelve').</p>
  
  <p>The date in question is always the last day of the period.  The period is defined in a cell in numeric form (for use in formulae).  For example, October is period 1.  So what I did to automate this was the following monstrous formula using the workbook name and 3 named ranges as 'helpers':</p>
  
  <pre><code>="For the " &amp; INDEX(MonthNumbers,MATCH(INDEX(PeriodMonths,'Franchise Fees'!U2,),CalendarMonths,0)) &amp; " Months Ended " &amp; TEXT(DATE(MID(CELL("Filename",A1),SEARCH("_",CELL("Filename",A1))-4,4),MOD('Franchise Fees'!U2+10,12),1)-1,"MMMMMMMMM DD, YYYY")
  </code></pre>
  
  <p>MonthNumbers is just a list of the numbers 1-12 in English (One, Two,...)</p>
  
  <p>PeriodMonths is the list of month names offset by 10 months (so that 1 = October)</p>
  
  <p>CalendarMonths is the list of month names in normal order (so that 1 = January)</p>
  
  <p>Now, I'm proud of this formula, but once my boss sees it she is going to flip out (she hates long formulae).  So I need to ask:</p>
  
  <p>Is there a simpler way to do this?  It feels like there should be.  Also, I CANNOT use VBA.  This is a macro-free workbook.</p>