Datedif doesn't work the same in Excel 2007

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?
 

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

Date format in Excel 2007 mm/dd/yy not appearing correctly 2
Find then highlight in yellow 6
pivot charting doesn't work for me - bill - 1
Regex - Date 5
EXCEL 2007 DATEVALE FUNCTION 3
Data search and extraction from multiple text files query 20
Excel 2007 text import as text not date 3
Deleting the confirmation responses in outlook deletes the meeting also 1

Top