Calculating Age-

F

fkheng

=IF(D15="","",DATEDIF(D15,TODAY(),"y"))

I have 2 fields, C and D. C is the field which represents Age and D
contains the date of birth.

With this formula, what I can achieve is that C will display the age by
calculating the date of birth in field D.

However, I would like to apply this formula to the whole worksheet. The
problem arises when there is no date of birth. Is it possible for me to
display a "N/A" sign if the D field validates to no date of birth?

Also, what if there is no date of birth in D, but there is a static age
value in field C which I want to maintain, this formula will also wipe
this value out. Could someone help me out here?
 
J

Jim

As to your last problem: A cell may only have one entry. You cannot have a
static value in it and also a formula.

The first part is easier:
=IF(DOB="","",YourFormula)
 

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

Calculating age from date of birth and ignoring if blank 5
age 3
create calculated field for age in pivot tables 4
calculate date of birth with an end date and age 1
"how do I calculate age by using date of birth details" 5
Count/Calculation According to Age of the Person 1
Age calculating formula 2
Calculating present age if date of birth is given. 3

Top