MySql - Get next date which satisfy a condition
<p>I have a mysql table called '<code>helper_leaves</code>' in which user have entered their leave dates for the next 2 months.</p>

<p>I would like to get <strong>2 upcoming working dates</strong> for a particular <code>user_id</code> which are <strong>NOT</strong> in the '<code>helper_leaves</code>' table and also should be <strong>next to the current date.</strong></p>

<pre><code>**id | user_id | leave_date** 

 1   |   1     | 2016-07-07 
 2   |   1     | 2016-07-09 
 3   |   1     | 2016-07-15 
 4   |   1     | 2016-08-03
</code></pre>

<p>I want write a  query to get next 2 working dates of <code>user_id = 1</code>, from now.
Please note, this table is having only the <strong>leave dates</strong>. But I want to get the next 2 <strong>availability dates</strong> .</p>

<p>For the sample data given, I expected to get <strong>2016-07-14</strong>  and <strong>2016-07-16</strong> as the next 2 working dates because today is <strong>2016-07-13</strong></p>

<p><strong>Note: All the dates which are not in this table is considered as a working date.</strong></p>

<p>Please help!!!!</p>