View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IT Olson[_2_] IT Olson[_2_] is offline
external usenet poster
 
Posts: 1
Default Is this a bug in Excel 2007?

I am trying to do countdown calculations. The numbers look good except my
months are off by one in the display.
If I calculate =now()-now() I get 1/0/00 0:00 (US date time format).
If I subtract 7/22/08 9:00 from 7/31/08 9:00 I get 1/8/00 0:00 and there is
obviously not a month and 8 days difference.

I did a count up timer from my date of birth and my birthday...on my
birthday I will be 30/12/31 ...okay I can see that. The day after I will be
31/1/1

I thought about the "There is no 0 month" however, it does calculate a 0
year AND a 0 day. Plus this is a calculation of how much time has gone by...0
months have gone by.

If some one knows the fix (or can confirm this is a bug) i would appreciate
it.