Forum Discussion
Solved
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 mont...
marianag129 Use the following formula-
=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"
marianag129 Use the following formula-
=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"
Thank you so much 😄