| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I was using Excel 2007, now 2003 and my Macros won't work | Excel Worksheet Functions | |||
| Excel 2007 shortcut Ctrl and + doesn't work | Excel Discussion (Misc queries) | |||
| Lost all my work in Excel 2007 | Excel Discussion (Misc queries) | |||
| Horizontal Scroll will not work in Excel 2007????? | Excel Discussion (Misc queries) | |||
| DateDif Average? Damn DateDif | Excel Worksheet Functions | |||
Linear Mode
