Age in years only
A blank cell is treated as 1/1/1900 which is 106 years ago.
If you want a blank returned, you could do something like
=IF(ISBLANK(A1),"",DATEDIF(A1,TODAY(),"y"))
Dave
--
Brevity is the soul of wit.
"Jamie" wrote:
I need a formula that will just return age in years from a given birthdate. I
have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate
then the formula returns 106
--
Jamie
|