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