Formula for calculating age

G

Guest

Hi,

What is a good formula for calcluating someone's current age? I have the
date of birth in one column and want to have their current age in the next
column. The fomula I am currently using is great if I have the column of
their age have decimals instead of a whole number...the decimal shows how far
into the year they are...but if I just want a whole number there it rounds it
up...so I guess I would need it to round down, eh? In any case, how would I
do this? Below is the formula I am currently using: =(NOW()-D6)/365

Thanks!
Kathy
 
R

R.VENKATARAMAN

use <datedif>function. see excel help
A1---5/31/1926
B1----7/23/2005
in any cell type
=datedif(a1,b1,"y")
will give you 79
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate age 3
Calculate Age 5
date of birth age formula 8
Calculating an age at a certain date 4
Calculating When Somebody Reaches a Certain Age 4
Formula for Date Calculation 7
Entering Days360 in Table formula 2
Age Formula 4

Top