| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extra month shown in date count
I am using =TODAY()-B5 in Excel 2000 and getting extra month in the count
I am using the Formula =TODAY()-B2 to display a running time (YR €“ MO €“ Days) since listed date. The problem is: It displays an extra month in the total. This includes actually showing €œ38 Years €“ 12 Months €“ 11 days€ when it should only be 38yr-11mo-11days. I am using Excel 2000 9.0.8948 SP-3 running on Windows XP Tablet Edition 2005 version 2002 SP2. Any ideas, help, solutions? Thanks, Iyvind |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extra month shown in date count
See this:
http://www.cpearson.com/Excel/datedif.aspx -- Biff Microsoft Excel MVP "IyvH" wrote in message ... I am using =TODAY()-B5 in Excel 2000 and getting extra month in the count I am using the Formula =TODAY()-B2 to display a running time (YR - MO - Days) since listed date. The problem is: It displays an extra month in the total. This includes actually showing "38 Years - 12 Months - 11 days" when it should only be 38yr-11mo-11days. I am using Excel 2000 9.0.8948 SP-3 running on Windows XP Tablet Edition 2005 version 2002 SP2. Any ideas, help, solutions? Thanks, Iyvind |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extra month shown in date count
What's in B5 (or B2, whichever one is correct)? What is the formula you are
using to calculate years, months, and days? -- Regards, Fred "IyvH" wrote in message ... I am using =TODAY()-B5 in Excel 2000 and getting extra month in the count I am using the Formula =TODAY()-B2 to display a running time (YR - MO - Days) since listed date. The problem is: It displays an extra month in the total. This includes actually showing "38 Years - 12 Months - 11 days" when it should only be 38yr-11mo-11days. I am using Excel 2000 9.0.8948 SP-3 running on Windows XP Tablet Edition 2005 version 2002 SP2. Any ideas, help, solutions? Thanks, Iyvind |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many persons in a month using a date | Excel Worksheet Functions | |||
| Count months away betwwen a strat and end date by month | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
Linear Mode
