Assuming your birthday is in A1

=DATEDIF($A$1,NOW(),"Y")&" Years, "&DATEDIF($A$1,NOW(),"YM")&" Months,
"&DATEDIF($A$1,NOW(),"MD")&" Days"

"Gdm/kmf" wrote:

I want excel to calculate the age of a subject by entering the date of birth
of such subject