Datedif doesn't work the same in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a lot of spreadsheets which use the datedif function. The answers
produced are different on Excel 2007 when compared to Excel 2000 or 2003.

Egregious examples (using dd/mm/yy date format) are
=DATEDIF("30/01/94","01/02/95","yd") which gives -1
or =DATEDIF("01/01/94","01/02/95","yd") gives 31 but
=DATEDIF("02/01/94","01/02/95","yd") gives 27

This seems like a bug, but I couldn't find much on the internet about this.

Is this a known issue? Is there a simple workaround?
 
Back
Top