title: Sick leave database
body: <p>I am new to coding and have taken on this small project and need some help!!    This is the basic set up for the project </p>
  
  <p>Sheet 1 </p>
  
  <pre><code>Name 1     Name 1        Name 2      Name 3
  1/1/2019   2/1/2019      1/1/2019    3/5/2019
  1/2/2019   2/2/2019      1/2/2019    3/6/2019
  1/3/2019   2/3/2019      1/3/2019    3/7/2019
  </code></pre>
  
  <p>Sheet 2 </p>
  
  <pre><code>               1/2/2019     1/2/2019       1/3/2019   
  Name 1         X                   X
  Name 2                             X              X
  Name 3         X                   X              X
  </code></pre>
  
  <p>Sorry this basic setup is not showing correctly. I hope this is not to confusing.  </p>
  
  <p>The problem I am having is sheet 1 list all the dates the employees enter one years worth and they are in multi columns.  Then sheet 2 is a calendar with a full year list on the top row.  Getting dates in sheet 1 to populate on sheet 2 in the  appropriate  location.   I have tried index match and using if then function with no success.  I could really use some guidance for how to do this project. Thank you for any help.  </p>