Convert Decimal Values in to Year,month,and days

[satishwin123]

Hi All,

I want to convert 13.52 in to Years, Months and days.

Pl. share me the excel formula for the same.

Thanks
Sat.

 

[Akashwani]

Hi and welcome to MrExcel.

Which Year/Month/Day do you expect to get from 13.52?

A bit more information and some sample data would be helpful.

Ak