Datedif doesn't work the same in Excel 2007

E

EricK

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top