=DAY(EOMONTH(E4,0)) doesn't work in Excel 03

B

Brendon

Does anyone know why the following function does not work
in 2003 when it worked on XP?
=DAY(EOMONTH(E4,0)) - Where E4 is the current month
also the following function also does not work?
=B6/DaysInMonth - Where B6 is a number.
Both now give a #NAME? error.
Thanks.
 
B

Brendon

I pasted into a new worksheet the formula example given in
help and I also get this error. Is this a bug with 2003?
 
H

Harlan Grove

I pasted into a new worksheet the formula example given in
help and I also get this error. Is this a bug with 2003?

If you read online Help for EOMONTH, you may discover that it's provided by the
Analysis ToolPak, which you must choose to load (it's not loaded by default)
using the Tools > Add-ins... menu command. Online Help for EOMONTH contains a
link to detailed instructions on how to do this.

As the old saying goes, when all else fails read the directions.
 

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

Top