On Sat, 11 Nov 2006 13:12:01 -0800, Mike
wrote:

Ron, sorry should have read your post correctly. the last one
=EOMONTH(DATE(2006,11,1),1) returns a #value! error

Mike


That being the case, it is likely that you are not calling the Analysis ToolPak
EOMONTH function, but perhaps some other function with the same name.

Ordinarily, if the ATP is not installed, you would get the #NAME error. But if
you had another UDF with the same name, you might be getting a VALUE error.

Check if the Analysis Tool Pak is installed.
--ron