Round Down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.

Casey N said:
I am determining how old a child was at a specific date. I am using the
Click to expand...
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?
 
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

Casey N said:
I am determining how old a child was at a specific date. I am using the
Click to expand...
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?
 
Back
Top