I need help with Excel
Thu, 06/21/2012 - 10:24am
 |
 14 years
|
I am calculating a person's age as of today.
In C3 the value is 4/10/1980
In C4 I have the formula
=ROUNDDOWN((DATEDIF(C3,$D$19,"m")/12),0)
The result should be 32 years old. I am getting a result of 31.
What should my formula be?
d19
what do you have in d19?
Streetpilot C340 Nuvi 2595 LMT
=today()
What I did using your example (and formula) was place "=today()" in cell $D$19 and it came up with the correct result.
Streetpilot C340 Nuvi 2595 LMT
Solved
=INT((TODAY()-C3)/365.25)
This is easier for me to understand
The result is
5 |Kasey Kahne |4/10/1980 |32
1490LMT 1450LMT 295w
Alternate
You could have just used this:
=DATEDIF(C3,$D$19,"y")
C3 the date in question
$d$19 today's date
the "y" instructs year. No rounding needed.
Garmin Nuvi 2450
Try this
=INT((TODAY()-C3)/365.25)
This is easier for me to understand
The result is
5 |Kasey Kahne |4/10/1980 |32
=IF(C3>0,(INT((TODAY()-C3)/365.25)),"")
If C3 has date - will return age,
if C3 is blank - cell with formula is blank.