End of Month Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks Dave, it works.



Dave Peterson said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=BOMONTH? 3
modified amortization schedule for open ended loan with EOM LPP ch 7
End of month function 3
EOMONTH compatibility issue (workaround?) 1
End of month calculations 4
Excel VBA 2003: how do I call an Analysis ToolPak function within 7
EOMONTH not allowed in Array Functions? 1
Question on Formula Audit function 3

Back
Top