Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
how to email excel 2007 worksheet with outlook 2007 | Excel Worksheet Functions |