new & interesting places for your GPS

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.

sponsored links



Navigation



User login

Leave this blank! This field helps block spambots.

poi factory



Who's online

There are currently 21 users and 97 guests online.

Online users

  • fishinreds
  • kmc
  • Juggernaut
  • blake7mstr
  • UnNamed
  • jjen
  • carol 2002
  • donaldb530
  • Garmin2597Guy
  • FZbar