tying to calculate year and months in with datedif

[Punquey]

E Purchase Date	F Today's Date
2/1/06	12/5/2017

<colgroup><col><col></colgroup><tbody>
</tbody>

Formula: =DATEDIF(E148,F148,"y")

I want it to be able to return back 11 Years 10 months. Currently it just returns back 11 years. I have tried "my" and "m", "y" but still not working. thanks for the help!

 

[barry houdini]

You need two DATEDIFS like this

=DATEDIF(E148,F148,"y")&" y "& DATEDIF(E148,F148,"ym")&" m"​

<strike></strike>