| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INEXPLICABLE FORMULA RESULT
Consider the following formula:
=(Date1+1094)-Date2 If I run that formula using the following dates: (02/25/2005+1094)-02/25/2008, the answer is -1.00. If I run the same formula with these dates: (04/16/2005+1094)-04/16/2008, the answer is -2.00! HELP!! How can this happen?! In case you're wondering, 2005 was NOT a leap year (2004 and 2008 were). -- William |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result does not match displayed result | Excel Worksheet Functions | |||
| Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Nested IF AND OR function Inexplicable error | Excel Worksheet Functions | |||
Threaded Mode
