Extra month shown in date count

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
 
F

Fred Smith

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

Count Records for this week, this month, this quarter and this yea 2
Count Records for this week, this month, this quarter, this year 5
Rounding date field up to next first of month, with existing formu 5
Conditional Format for a date 1 month before Expiration in Excel 2 2
Month, DATE, Week 7
Count how many persons in a month using a date 2
Summing days that match a criteria and date 3
Date calculation 3

Top