Calculating Age

[alidde]

I am trying to calcutate a persons age using this formula =IF(E4<>"",DATEDIF(E4,A4,"y")&"yrs"). Unfortunately, the column sates FALSE (E4 is the Date of Birth and A4 is today's date). Could someone explain what am I doing incorrectly?

Thank you

[Ace_XL]

Is E4 blank? If it is, the formula will show 'False'

[Bob Phillips]

That probably means that E4 IS blank.

[alidde]

Yes it is blank. However, I want it to remain blank until I input a date of birth.

[thair]

you should input at E4 date of birth

[Ace_XL]

in that case change your formula to

=IFERROR(DATEDIF(E4,A4,"y")&"yrs","")