|
Datedif doesn't work the same in Excel 2007
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? |
Datedif doesn't work the same in Excel 2007
Yes, there is a bug in XL-2007.
"EricK" wrote: 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? |
| All times are GMT +1. The time now is 02:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com