Example count age from microsoft excel

Format

=DATEDIF(“birthdate”,date,”y”)

example 1

=DATEDIF(“1-jan-1970″,TODAY(),”y”)

result 1 => if today 20 dec 2011 then age = 41

example 2

=DATEDIF(“1-jan-1970″,DATE(2012,1,1),”y”)

result 2 => 42