Bug with DATEDIF and Md is it possible ?
 

Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.

Bug with DATEDIF and Md is it possible ?
 

Sorry - Correction : 03/01/2008 instead 03/01/2009


"MichDenis" a écrit dans le message de news:
...
Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.

Bug with DATEDIF and Md is it possible ?
 

I believe the syntax uses commas, rather than semicolons? try the following:
=DATEDIF(A1,A2,"MD")

HTH,
Keith

"MichDenis" wrote in message
...
Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.

Bug with DATEDIF and Md is it possible ?
 

I know, it's simply because i work with a french version and we use semicolons...

Have you tried your formula with the suggested dates ?

Thank for your participation.




"ker_01" a écrit dans le message de news:
...
I believe the syntax uses commas, rather than semicolons? try the following:
=DATEDIF(A1,A2,"MD")

HTH,
Keith

"MichDenis" wrote in message
...
Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.

Bug with DATEDIF and Md is it possible ?
 

Whether semi-colons or commas are used as separators is a function of
the application language (semi-colons are typically used in European
languages).

The problem is that DATEDIF() uses the length of the first month to
determine what a "month" is.

This problem (with variations of the given example) has been discussed
here many, many times.

Because "month" is a fuzzy concept, there's simply no definition of
"month" that will allow both algorithmically consistent, and generally
acceptable, results without including this kind of anomaly.


In article ,
"ker_01" wrote:

I believe the syntax uses commas, rather than semicolons? try the following:
=DATEDIF(A1,A2,"MD")

HTH,
Keith

"MichDenis" wrote in message
...
Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.

Bug with DATEDIF and Md is it possible ?
 

Thanks for your explanation.


"JE McGimpsey" a écrit dans le message de news:
...
Whether semi-colons or commas are used as separators is a function of
the application language (semi-colons are typically used in European
languages).

The problem is that DATEDIF() uses the length of the first month to
determine what a "month" is.

This problem (with variations of the given example) has been discussed
here many, many times.

Because "month" is a fuzzy concept, there's simply no definition of
"month" that will allow both algorithmically consistent, and generally
acceptable, results without including this kind of anomaly.


In article ,
"ker_01" wrote:

I believe the syntax uses commas, rather than semicolons? try the following:
=DATEDIF(A1,A2,"MD")

HTH,
Keith

"MichDenis" wrote in message
...
Hi,

Does someone have an explanation ?

2 Dates in 2 cells
A1 = 01/31/2008
A2 = 03/01/2009

With this formula : =DATEDIF(A1;A2;"md")
The answer = -1

With this 2 dates :
A1 = 01/30/2008
A2 = 03/01/2009
With this formula : =DATEDIF(A1;A2;"md")
The answer = 0

Is it really a bug ?

Thank for your participation.