| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INEXPLICABLE FORMULA RESULT
Exactly, so the second includes an extra day for 2008.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INEXPLICABLE FORMULA RESULT
add 365 x 3 yrs = 1095
since you are using 1094, you will get -1 -- Hope this helps. Thanks in advance for your feedback. Gary Brown "William" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INEXPLICABLE FORMULA RESULT
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INEXPLICABLE FORMULA RESULT
You are correct, 2008 was a leap year.....
therefore, on your second formula to go from 4/16/05 to 4/16/08 takes 1 'extra' day (because of Feb 29, 2008, which does not fall in the range of your first formula). Therefore, because of the 1 extra day, it is a result of -2, instead of -1. -- John C "William" wrote: 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 |
|
#6
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 |
|
#7
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 | |||
Linear Mode
