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

Similar Threads

Find then highlight in yellow 6
Emulating older pivot table "engine" in Excel 2007? Need help... 0
Date format in Excel 2007 mm/dd/yy not appearing correctly 2
pivot charting doesn't work for me - bill - 1
Incorrect date value when open DBF file in Excel 0
Dates and Averages 0
Data search and extraction from multiple text files query 20
Excel 2007 text import as text not date 3

Top