Thread
:
Bug with DATEDIF and Md is it possible ?
View Single Post
#
2
Posted to microsoft.public.excel.programming
michdenis
external usenet poster
Posts: 135
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.
Reply With Quote
michdenis
View Public Profile
Find all posts by michdenis