# I need help with Excel

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?

--
1490LMT 1450LMT 295w

### 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

 spokybob wrote: =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.