End of Month Function
 

I write an formula by use EOMONTH function and it return #NAME? to me and I
aready install Analysis Tools - Add In and restart the computer alread. But
it still doesn't work. Could any one help please. Thank you.

End of Month Function
 

What happens if you select that cell with the =eomonth() formula
then hit F2 (to edit)
followed by Enter

If you have lots of these, maybe you could just select all the cells
edit|Replace
what: = (equal sign)
with: = (same equal sign)
replace all

Excel will see it as a change and reevaluate each formula.

Tony wrote:

I write an formula by use EOMONTH function and it return #NAME? to me and I
aready install Analysis Tools - Add In and restart the computer alread. But
it still doesn't work. Could any one help please. Thank you.

--

Dave Peterson

End of Month Function
 

Thanks Dave, it works.



"Dave Peterson" wrote:

What happens if you select that cell with the =eomonth() formula
then hit F2 (to edit)
followed by Enter

If you have lots of these, maybe you could just select all the cells
edit|Replace
what: = (equal sign)
with: = (same equal sign)
replace all

Excel will see it as a change and reevaluate each formula.

Tony wrote:

I write an formula by use EOMONTH function and it return #NAME? to me and I
aready install Analysis Tools - Add In and restart the computer alread. But
it still doesn't work. Could any one help please. Thank you.

--

Dave Peterson