Find a person’s age in Excel Sep06 '04

# (1 of 6): Jonathan

11 months after the fact. (Wed 03 Aug 2005, 1:21 PM CST)

With the last formula, if you format the cell to only show the whole number, it will round it up a couple days before the birth day and you won't have the good person's age. Here's the exact formula you should use to find a person's age:

=DATEDIF(birthdate,now(),"y")

You won't find anything better than that ;)

# (2 of 6): George » medicarenews.net

2 years, 1 month after the fact. (Wed 25 Oct 2006, 3:39 PM CST)

If you remove the remainder using your method it will round UP if a person is 21.5 years old it will say they are 22.

Make sure you use =Floor(your_function,1) to round down.

Previous comment Return to entry

# (3 of 6): Matthom

2 years, 1 month after the fact. (Wed 25 Oct 2006, 4:48 PM CST)

George, so you're saying that formatting the cell to only show the whole number will automatically round it at the same time?

I was under the impression that it simply drops the remainder, without doing any rounding.

So, 21.5 would be 21.

Is this an incorrect assumption?

Previous comment Return to entry

# (4 of 6): Mark Rollen Mark

3 years, 11 months after the fact. (Sat 30 Aug 2008, 3:34 AM CST)

HEllo . you can use this very short formula... =DATEDIF(A2,TODAY(),"y") this wil solve the accurate age of a person :-) kramshock!

Previous comment Return to entry

# (5 of 6): Mark

3 years, 12 months after the fact. (Mon 01 Sep 2008, 4:48 AM CST)

Sorry the 'A2' in my comment is birthdate

Previous comment Return to entry

# (6 of 6): Ross

4 years after the fact. (Sun 21 Sep 2008, 10:25 AM CST)

leap years??????????

Previous comment Return to entry