View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IyvH IyvH is offline
external usenet poster
 
Posts: 1
Default 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