Need Assistance With Date Formula

[meppwc]

I would appreciate assistance with a date formula.
All of my static dates are in column C starting with C1, using a format of xx/xx/xxxx.
In column D starting with D1, I am using =(DATEDIF(C1,TODAY(),"Y") which tells me how many years there are between the value of C1 and today's date.
What I would like to do also have the amount of remaining months along with the years in the same cell.
For example: "16 Years and 2 Months"

 

[SanjayGMusafir]

This is the formula I use (got it from internet but don't remember the source) to calculate exact age upto the days. You can use it in Cells D1 and below and eliminate/modify the part you don't need. Try it and revert -

=IFS(ISBLANK(C1),"",
TRUE,
DATEDIF(C1,TODAY(),"y")&" yrs "&
          DATEDIF(C1,TODAY(),"ym")&" mths "&
          (DATE(YEAR(TODAY()), MONTH(TODAY()) - DATEDIF(C1,TODAY(),"m"), DAY(TODAY())) - C1)&" days")

 

[Dave Patton]

T202310a.xlsm
	C	D
1	02-Aug-2007	16 Years and 2 Months
2
1b

Cell Formulas
Range	Formula
D1	D1	=DATEDIF(C1,TODAY(),"y")&" Years and "&DATEDIF(C1,TODAY(),"ym")&" Months"

 

[meppwc]

Thanks so much

 

[Dave Patton]

Thanks for the feedback.