Note that this gives nonsense answers when the beginning month is longer
than the end month:

on 1 March 2006, this formula will, for

A1: 31 January 1988

return "17 years, 1 months, -2 days"

Since you don't need the days, better to ditch the extra functions and
use

=DATEDIF(A1, TODAY(), "y") & " years old"

or,

=IF(DATEDIF(A1,TODAY(),"y")=18,"OK","Too young")



(You could use NOW(), instead, but adding the time doesn't matter with
DATEDIF)


In article ,
"Bob Phillips" wrote:

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"