End of Month Function

T

Tony

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.
 
D

Dave Peterson

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.
 
T

Tony

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...
 
Top