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 6 users and 70 guests online.

Online users

  • WVU 1 FAN
  • TWC42
  • Strephon_Alkhalikoi
  • jabbaman
  • ckpitts9
  • BigJohnM