Calculating Age-

  • Thread starter Thread starter fkheng
  • Start date Start date
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?
 
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)
 
Back
Top