It's still there but it needs to be installed, it has always been part of
the Analysis Toolpak (same with excel 2000), keep the Office/Excel CD handy,
do toolsadd-ins and select Analysis Toolpak and follow the instructions

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"DavidC" wrote in message
...
Hi,

Have found an interesting situation. I run Office 2000, and Excel has a
neat function called "eomonth". This allows a spreadsheet to be set up
with
the start and end of month dates automatically filled in. My colleague
has
2003, and lo and behold, the "eomonth" function has been removed. We
found a
work arround courtesy of John Wallenbeck, but have to wonder and ask the
question, WHY does microsoft remove good functionality in later versions.
Aside from the apparent illogicality of the move, it will render any
spreadsheet using that or any other simillar function, useless when opened
in
a later version.

Thye general rule is that there has been backward compatibility from one
version to the next, yet this is one clear example where the backward
compatability is missing.

Does anyone have any idea why a perfectly good and workable function
should
be removed?

regards

DavidC