Calculating dates to get correct number of years

G

Guest

Is there a way to force Excel (2000) to not round off numbers in order to get
the correct answer you want? For example, when you subtract the exit date
(9/30/2004) from a person's date of birth (11/15/1952), Excel returns the
value of 51.956. If the number was not rounded off, the person's correct
years of birth is 51. However, if you allow Excel to round the number off,
then it becomes 52.
 

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

Calculating exact years between dates 1
Calculating age from date of birth and ignoring if blank 5
Excel - Calculate age from DOB in years, months days 7
How do I calculate a persn's age in years & months in Excel? 4
Date formula rounded up 2
calculating ages 3
How does Excel allow for leap years? 2
Date Calculations 4

Top