Round Down

[Casey N]

I am determining how old a child was at a specific date. I am using the following formula: =year(a3)-year(a2). My problem is that the result is always rounded up, giving me an age that is actually one year older. Can anyone help me?

 

[Andy B]

Hi

This is because your are only looking at the years, rather than the dates
themselves. If you want to use this method, use =YEAR(A2)-YEAR(A1)-1

For more info on dates, see Chip's site:
http://www.cpearson.com/excel/datetime.htm#AddingDates

Andy.

I am determining how old a child was at a specific date. I am using the

following formula: =year(a3)-year(a2). My problem is that the result is
always rounded up, giving me an age that is actually one year older. Can
anyone help me?

 

[Chris Hoffman]

Casey,
Assuming that A2 is the birthdate, you can use this formula in place of
your formula and get the number of years old:
=ROUNDDOWN((A3-A2)/365.2422,0). The only issue is that they don't get a
year older until the day after their birthday. I hope this helps. Have a
great day!

Chris Hoffman

I am determining how old a child was at a specific date. I am using the

following formula: =year(a3)-year(a2). My problem is that the result is
always rounded up, giving me an age that is actually one year older. Can
anyone help me?

 

[JE McGimpsey]

use

=DATEDIF(A2,A3,"y")

If you're not using XL2000 (where documentation is in Help), check

http://cpearson.com/excel/datedif.htm

for documentation.