title: Excel: How to color the weekends with concatenated date and conditional formating
body: <p>I have created a timesheet where the year and month is concatenated in a cel and where the dates fills the first column. The day dates start with "1" in cel A6 and the second date is a formula "=A6 + 1". Plain and simple. But now I would like to color only the weekends in grey. I've searched on the internet and in the timesheets that I had but in Excel 2016 it won't work. Could anyone help me please?</p>
  
  <p>It looks like this:</p>
  
  <pre><code>    Day  | Start    |  Stop       | lunch      |Total hours     |
      1      09:00      17:30           0:30         08:00
      2
      3
      4      09:15      17:30           0:15         08:00
      5      09:00      17:30           0:30         08:00
      6      09:00      17:30           0:30         08:00
      7      09:00      17:30           0:30         08:00
      8      09:15      17:30           0:15         08:00
      9      09:00      17:30           0:30         08:00
      10
  </code></pre>
  
  <p>etc...
  I've tried: </p>
  
  <pre><code>    =WEEKDAG(DATUM($H$1;$H$2;$A$6);2) &gt; 5
  </code></pre>
  
  <p>where WEEKDAG = Weekday, Datum = date, H1 and H2 are the Year and the Month. but it doesn't work. Nothing happens actually. I've tried to leave the dollar sign on the column A$6 but it doesn't work neither. I've tried to change the format of the cells in General, text and numbers, no chance....
  Please advice?</p>