View Single Post
  #1   Report Post  
Frank Malone
 
Posts: n/a
Default Datevalue if born before 1930

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.