title: Need to generate next date from a given date after certain given interval in excel
body: <p>I am trying to generate a date from a given date after every 2 years and after every 6 months. </p>
  
  <p>For example :</p>
  
  <p>(For 2 Years)</p>
  
  <p>Given_Date : 1-Jan-2016<br>
  Next_date  : 1-Jan-2020</p>
  
  <p>// Since the 1-Jan-2018 has already passed.</p>
  
  <p>(For 6 month)</p>
  
  <p>Given Date : 1-dec-2017<br>
  Next Date : 1-June-2019  </p>
  
  <p>//  6 month interval based on start date.</p>
  
  <p>So i tried to Use Edate and IF and Mod function. </p>
  
  <p>EDATE(E3,IF(MOD(ROUND(DATEDIF(E3,TODAY(),"y"),0),2)=0,2,3)*12)</p>
  
  <p>It kinda work only for next date but not for next to next date.  I need something dynamic that works for all the future dates. </p>