How do I convert years into months and days?

Hello!

I'm trying to figure out how to convert something, say from 1 year, 6 months and 12 days to read as 18 months and 12 days. The formula I'm currently working with is:

DATEDIF(D7966,E7966,"y")&" years "&DATEDIF(D7966,E7966,"ym")&" months "&DATEDIF(D7966,E7966,"md")&" days"

but I don't know how to remove the year portion without it just not including it.

Any input is greatly appreciated!!

Thanks in advance!!!!!!

maybe
DATEDIF(D7966,E7966,"y")*12+DATEDIF(D7966,E7966,"ym")&" months "&DATEDIF(D7966,E7966,"md")&" days"

Originally Posted by humdingaling

Formula:

=DATEDIF(D7966,E7966,"m")&" months "&DATEDIF(D7966,E7966,"md")&" days"

reading on the function itself
https://exceljet.net/excel-functions...tedif-function

100% correct. Just removing the "Y" portion of the formula gives just the month count. That link was great! Thank you so much!!