Showing zero if DOB not confirmed

[VincentF]

Hi,

I', currently using the following formula to show Age from DOB;
=INT(YEARFRAC(C11,TODAY()))

What I would like to do is show the age as zero if no DOB is included.

Can someone assist me in modifying this formula?

Thanks
Vincent

 

[VincentF]

At the moment when there is no DOB added, the age cell automatically calculates and I have 116


DOB:
Age: 116
Address:
Contact number:

 

[Nebu]

Hi:

Something like this

=If(DOB="",0,INT(YEARFRAC(C11,TODAY())))


Thanks

 

[VincentF]

Hi Nebu - the calculation shows #NAME?

 

[Nebu]

Hi:

I gave DOB="" coz I do not know which column on your workbook the DOB is entered, you will have to replace the DOB in the given formula with the cell reference in your file.

Thanks

 

[VincentF]

Thanks Nebu