As I have not had an occasion to report anything in the past, I'm not really
sure of what the procedure is; so, if you wouldn't mind, I'll let you report
it. Thanks.

No problem Rick, I will report it on Connect for you

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Rick Rothstein" wrote in message ...
As I have not had an occasion to report anything in the past, I'm not really
sure of what the procedure is; so, if you wouldn't mind, I'll let you report
it. Thanks.

As for getting it fixed (assuming Microsoft would want to even do that with
an unsupported function)... any fix will come too late. It appears that the
bug was introduced in Service Pack 2... I guess the next opportunity to fix
the bug wouldn't come until Service Pack 3, and who knows when that will be.
On top of that, not everybody updates to the latest Service Pack as soon as
they come out (look at the OP... he didn't even install SP1), so there will
be a lot of SP2 versions of XL2007 out there for what will probably be a
"long time". I guess this means we volunteers here will have to stop
recommending the use of DATEDIF from now on (who knows what else got screwed
up besides the problem the OP raised). Now, if we could only retract all
those previous recommendations to use DATEDIF that we all have posted in the
past (and which are archived all over the place).

--
Rick (MVP - Excel)


"Ron de Bruin" wrote in message
...
Hi Haddox

No Sp and SP1 are working OK

Sp2 is the problem

Also, is there a system whereby we can notify MS of this type of event
(if indeed it is a bug)?

Rick or I will report it but I think it will never be fixed because this
formula is not supported by Microsoft.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Haddox" wrote in message
...
Thanks for the responses, everyone. My 2007 is on SP2. Also, is there a
system whereby we can notify MS of this type of event (if indeed it is a
bug)? "Rick Rothstein" wrote:

That's odd... I get 9 in XL2003 and I get 122 in XL2007.

My XL2007 is at SP2... what service pack level are you at?

--
Rick (MVP - Excel)


"NBVC" wrote in message
...

I get 9 in both 2003 and 2007


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=111053