<div>
the second value after the column will shift the number of months (not using +1)<br />
<b>=EOMonth(A2,1)</b> though your formula should still return the first of the next month.<br />
And your error is likely due to the value in A2 being text, not a date.<br />
try typing 01/09/2012 in celss A2 to test if this is the case.
</div>


the second value after the column will shift the number of months (not using +1)
=EOMonth(A2,1) though your formula should still return the first of the next month.
And your error is likely due to the value in A2 being text, not a date.
try typing 01/09/2012 in celss A2 to test if this is the case.

<div>
Many thanks for the feedback
</div>


<div>
Hi the barman<br />
<br />
I am not after the first of the next month but &quot;October 12&quot; as the end result.
</div>


Hi the barman

I am not after the first of the next month but "October 12" as the end result.

<div>
Where above it says <b>=Format</b> it should be <b>=Text</b> the Format is a function of VBA not an Excel formula :)
</div>


Where above it says =Format it should be =Text the Format is a function of VBA not an Excel formula :)

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I am getting a #Name error when I insert the following<br />
Formula in cell B2 =EOMonth(A2,0)+1 when a1 say sep-12<br />
I want B2 to say October 12...
</div>
</div>


Hi Experts

I am getting a #Name error when I insert the following
Formula in cell B2 =EOMonth(A2,0)+1 when a1 say sep-12
I want B2 to say October 12...

Eomonth formula error

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.