Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bug with DATEDIF and Md is it possible ?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATEDIF | Excel Worksheet Functions | |||
DateDif ? | Excel Worksheet Functions | |||
=DATEDIF | Excel Worksheet Functions | |||
Datedif | Excel Programming | |||
DateDif Average? Damn DateDif | Excel Worksheet Functions |