Help with formula for years and months

[marianag129]

Hi, i was hoping someone could help me setting up a formula for calculating the years and months between a date and today. I have the date of birth of students and need to put how many years and months old they are. I use excel in spanish so all the formulas y have tried are in spanish and i just couldnt get them right. It need to look something like this:

I need to this for more than a thousand students and im going insane doing it manually. 

I would appreciate a lot if you could help me out ❤️

[#2 · Accepted solution]

@marianag129 Use the following formula-

=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"

[#3]

Thank you so much 😄