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

  • Thread starter Thread starter Brendon
  • Start date Start date
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.
 
I pasted into a new worksheet the formula example given in
help and I also get this error. Is this a bug with 2003?
 
I pasted into a new worksheet the formula example given in
help and I also get this error. Is this a bug with 2003?
Click to expand...

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