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