title: Figure out the first Calendar Saturday based on the first day of the month
body: <p>Essentially what I'd like to be able to do is to find the first Saturday of the month based on the first day of the month.  And I get conflicting information concerning this.</p>
  
  <p>I could have the end user choose the first Saturday of the month, but I'd rather not leave that impressive feat to their discretion.</p>
  
  <p>For example, this coming January starts on a Thursday.  What I'd like is to click on a button that says JAN and then VBA would look at the 2015 calendar year and say that the first Saturday is on the third.</p>
  
  <p>If that's even possible.  My reporting goes SAT-SUN, and SUMIFS filters ">="&amp;(SUN DATE) and "&lt;="&amp;(SAT DATE) by week.</p>
  
  <p>So I click on JAN, which sets the date to 010115, Excel/VBA does a little magic, determines that the first SAT is the 3rd, SUM statements add a few days to set the date range for each reporting week.</p>
  
  <p>If the answer to this is no, that's fine I will just have to stick to my other idea.</p>