Hmm.. that worked for me.

Here's another couple of approaches, see if they work for you.

=DATEDIF(D4,NOW(),"y")

which works with D4 as text or as a date.


or more similar to your original formula with D4 as text..

=YEAR(NOW())-YEAR(DATEVALUE(D4))



"Frank Malone" wrote in message
...
I'm using =(year(now()-datevalue(d4))-1900)
I enter DOB as text and excel finds age of person if born 1930 or after
1930. But if year of birth is 1929 or earlier get error #num! So is their
some way to get around this problem.