Extra month shown in date count

  • Thread starter Thread starter IyvH
  • Start date Start date
I

IyvH

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
 
What's in B5 (or B2, whichever one is correct)? What is the formula you are
using to calculate years, months, and days?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use month in cell date to sum all relevant cells 2
Rounding date field up to next first of month, with existing formu 5
Counting dates with specific criteria 1
calculating months between dates 4
Working Days of Week and DUE DATE for PAYMENT 4
Divide month into two payroll periods 5
Count dates for previous month 3
Count between two dates using sumproduct 6

Back
Top