| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INEXPLICABLE FORMULA RESULT
Thanks, everyone. Duuuh, "2008 was a leap year" . . . !
-- William "David Biddulph" wrote: You've answered the question yourself. 2008 was a leap year. From 25 Feb 2005 to 25 Feb 2008 is 1095 days (3 * 365) From 16 Apr 2005 to 16 Apr 2008 is 1096 days (3 * 365, + leap year day in 2008) -- David Biddulph "William" wrote in message ... 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INEXPLICABLE FORMULA RESULT
yes 2008 is
"William" wrote: Thanks, everyone. Duuuh, "2008 was a leap year" . . . ! -- William "David Biddulph" wrote: You've answered the question yourself. 2008 was a leap year. From 25 Feb 2005 to 25 Feb 2008 is 1095 days (3 * 365) From 16 Apr 2005 to 16 Apr 2008 is 1096 days (3 * 365, + leap year day in 2008) -- David Biddulph "William" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
