Re: DATEDIF "md" 2007 issue?
- From: "Ron de Bruin" <rondebruin@xxxxxxxxxxxx>
- Date: Mon, 29 Jun 2009 23:29:32 +0200
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" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in message news:uFJxj%23P%23JHA.1488@xxxxxxxxxxxxxxxxxxxxxxx
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" <rondebruin@xxxxxxxxxxxx> wrote in message news:%236uiDyP%23JHA.3544@xxxxxxxxxxxxxxxxxxxxxxxHi 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" <Haddox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:CFA58E8B-3D11-4F87-B5C6-34FFA2BC92B1@xxxxxxxxxxxxxxxxThanks 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" <NBVC.3ujvo5@xxxxxxxxxxxxxxx> wrote in message news:NBVC.3ujvo5@xxxxxxxxxxxxxxxxxx
>
> 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/showthread.php?t=111053
>
-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com
.
- References:
- DATEDIF "md" 2007 issue?
- From: Haddox
- Re: DATEDIF "md" 2007 issue?
- From: NBVC
- Re: DATEDIF "md" 2007 issue?
- From: Rick Rothstein
- Re: DATEDIF "md" 2007 issue?
- From: Haddox
- Re: DATEDIF "md" 2007 issue?
- From: Ron de Bruin
- Re: DATEDIF "md" 2007 issue?
- From: Rick Rothstein
- DATEDIF "md" 2007 issue?
- Prev by Date: RE: How do I keep the divisor constant in calculating percentage remai
- Next by Date: Re: How do I keep the divisor constant in calculating percentage remai
- Previous by thread: Re: DATEDIF "md" 2007 issue?
- Next by thread: Re: DATEDIF "md" 2007 issue?
- Index(es):
Relevant Pages
|
