Find the end-of-month date from any date entered in MS Excel
<p>I need to take the date from one cell, find the end of the month that that date falls into, then add one calendar month.</p>

<p>Example: </p>

<pre><code>Enter jan 13: jan 13 end of month is Jan 31, + 1 month is Feb 28 (or 9 on leap year).

Feb 19: = March 31

March 2 = 30 April

March 30 = 30 April

March 31 = 30 April
</code></pre>

<p>etc etc</p>

<p>Is there an excel formula that will do this? I don't want any macro/ VBA stuff.</p>