Datedif formula needed for months and days

[John Henworth]

Hello
I have a Dateif formula to work out years from a date, is there a way of working out the months and days

Example from December 6th 1946 to todays date 74 years 4 months 18 days

[JohnTopley]

Parameters for DATEDIF

"y" Difference in complete years
"m" Difference in complete months
"d" Difference in days
"md" Difference in days, ignoring months and years
"ym" Difference in months, ignoring years
"yd" Difference in days, ignoring years

You need "ym" and "md" respectively.

[John Henworth]

Thanks John
I have inserted YM in playes of M and it says 18 months
What I want is the total years and months and days from the inserted date
Regards John

[torachan]

see attached with formatting in appropriate cells
torachan