Coversion for Months within a year

[carabale]

I need to create a conversion chart for Months within a year. Example: User type in cell A2 ".1" and cell B2 displays "1 mo, 7 days." Any suggestions?

I tried dateif but for that I need two actual dates to compare. In the example above the user enter a decimal number.

Thanks in advance.

 

[ken2step]

So are you assuming that 1 month is 30 days?

 

[ken2step]

=ROUND((365*A2)/30,0)&" Mo "&ROUND(MOD((365*A2),30),0)&" days"

 

[carabale]

This almost works. The problem is the rounding particularly the months. Example: .30 should be equal to 3 mo 20 days, but because of the rounding, I get 4 mo 20 days. Any ideas?

 

[carabale]

I used ROUNDDOWN on the first portion of the formula and got what I wanted. Thanks a lot ken2step.