How to add 1 Month to DATE in an IF Statement?
<p>I am creating a personal spreadsheet in Excel. I have a countdown that counts the days until a specific date, at which point when it hits 0, I wish to add 1 <b>Calendar</b> month onto the specific set date, so for example...<br>
<hr>
<i>State 1</i><br>
Set Date &nbsp;&nbsp;&nbsp;Days Until Set Date &nbsp;&nbsp;&nbsp;
<br>01/01/16 &nbsp;&nbsp;&nbsp; 1</p>

<hr>

<p><i>State 2</i><br>
Set Date &nbsp;&nbsp;&nbsp;Days Until Set Date
<br>01/01/16 &nbsp;&nbsp;&nbsp;0 &nbsp;&nbsp;(Day hits 0, 1 calendar month is added)</p>

<hr>

<p><i>State 3</i><br>
Set Date &nbsp;&nbsp;&nbsp;Days Until Set Date
<br>02/01/16 &nbsp;&nbsp;&nbsp;31 &nbsp;&nbsp;
<hr>My guess is that I would need to use an <code>IF</code> statement? I hope I have clearly explained my plans! Note: Each month would start on the 1st. </p>