title: Repeat cell values and increment them afterwards
body: <p>I'm trying to set up a structure in a sheet that allows for a date value to be incrementally (monthly) increased from a given start date. However, I also want each month to be repeated x times before it moves on to the next month, which should then also be repeated x times before moving on, and so on, until a given end date.</p>
  <p>I've created <a href="https://docs.google.com/spreadsheets/d/1dJoWA4SdELXgcOOhcmhMGQvg_wKq0wYE8LVPrlKlxwA/" rel="nofollow noreferrer">this sheet</a> to exemplify my desired output.</p>
  <p>In the <a href="https://docs.google.com/spreadsheets/d/1dJoWA4SdELXgcOOhcmhMGQvg_wKq0wYE8LVPrlKlxwA" rel="nofollow noreferrer"><strong>Example</strong></a> tab, I have a list of names (Sales reps) which, in this case, correspond to the &quot;x&quot; I mentioned previously. This means that I would like each date value to be repeated the same number of times as there are sales reps, before moving on to the next month and repeating it again the same number of times as there are sales reps. This also means that, if I increase the number of sales reps at some point, that should also be reflected in the number of times that a month is repeated. Also, the start and end dates should match the values in <em>D3</em> and <em>D5</em>.</p>
  <p>In columns <em>D</em> and <em>E</em> in the <strong>Example</strong> tab, I just wrote the kind of behaviour I'm looking for in static values. Can anyone help me fill in the <a href="https://docs.google.com/spreadsheets/d/1dJoWA4SdELXgcOOhcmhMGQvg_wKq0wYE8LVPrlKlxwA" rel="nofollow noreferrer"><strong>Desired solution</strong></a> tab with a formula that automatically achieves that? That would be much appreciated </p>
  <hr />
  <p><strong>EDIT: THINGS TRIED SO FAR</strong></p>
  <p>I created a new tab called <a href="https://docs.google.com/spreadsheets/d/1dJoWA4SdELXgcOOhcmhMGQvg_wKq0wYE8LVPrlKlxwA" rel="nofollow noreferrer"><strong>Undesired solution</strong></a> where I show a hacky workaround that I tried, but that I would like to keep away from. The main reason for that is that, if the number of sales rep was to change:</p>
  <ul>
  <li>I would have to manually update the first few cells of column <em>F</em></li>
  <li>I would have to manually update the formula used from <em>G5</em> onwards</li>
  </ul>