title: How can I find and show all Saturdays in a year but show 1st of each month if it falls in the week in Excel?
body: <p>This one is driving me up a wall, so I hope somebody can help. Here's what I'd like to do.</p>
  
  <p>I'd like dynamically show the Saturdays in each month, starting from 1/1/2014. If at any point, the first of the month occurs between the previous Sunday and the Saturday following it, I'd like to show the first of that month and then the end of the week. I have one exception to that, which is 1/1. Here are some examples. Take 1/1/2014:</p>
  
  <p>The previous Sunday to 1/1/2014 is 12/29/2013. The following Saturday is 1/4, and 1/1 falls in between that week. However, I'd like to begin with the first Saturday in January, since it's the first week in the year. So, here's how January would look:</p>
  
  <blockquote>
    <p>1/4/2014   1/11/2014   1/18/2014   1/25/2014</p>
  </blockquote>
  
  <p>Now, since the next Saturday falls in a new month, I'd like to show the end of January and have the next cell be the following Saturday in February, like so:</p>
  
  <blockquote>
    <p>1/4/2014   1/11/2014   1/18/2014   1/25/2014   <strong>1/31/2014</strong>   <strong>2/1/2014</strong></p>
  </blockquote>
  
  <p>Here's February into March, which is similar:</p>
  
  <blockquote>
    <p>2/1/2014   2/8/2014    2/15/2014   2/22/2014   <strong>2/28/2014</strong>   <strong>3/1/2014</strong></p>
  </blockquote>
  
  <p>These are kind of consistent in that the next Saturday following the end of these two months happens to be the first of the next month. March into April is different, though. Consider:</p>
  
  <blockquote>
    <p>3/1/2014   3/8/2014    3/15/2014   3/22/2014   <strong>3/29/2014</strong>   <strong>3/31/2014</strong>   <strong>4/5/2014</strong></p>
  </blockquote>
  
  <p>Here, the end of March falls in between the two months...</p>
  
  <p>I hope this is clear because it's making my brain hurt. </p>
  
  <p>Thanks for reading!</p>