Forum Discussion
marianag129
Oct 02, 2024Copper Contributor
Help with formula for years and months
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 ❤️
marianag129 Use the following formula-
=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"
2 Replies
Sort By
- Harun24HRBronze Contributor
marianag129 Use the following formula-
=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"
- marianag129Copper ContributorThank you so much 😄