 <p>Your issue is with attempting to change your month by adding 1. 1 in date serials in Excel is equal to 1 day. Try changing your month by using the following:</p> <pre><code>NewDate = Format(DateAdd("m",1,StartDate),"dd/mm/yyyy") </code></pre>