Formula for calculating age

K

Kathy

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
 

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
Calculating When Somebody Reaches a Certain Age 4
Entering Days360 in Table formula 2
Calculating age 1
date of birth age formula 8
Calculating an age at a certain date 4
Calculate Age 5
Calculate Age 3

Top