Originally Posted by Kevin B

Assuming your 63 days is in cell A1, the following formula in B1 will do the
trick:

=IF(A1<30,A1&" days",INT(A1/30)&" months and "&MOD(A1,30)&" days")

--
Kevin Backmann


"Jon" wrote:

Greeting,

I have 63 days, the Question is How to convert it to 2 months and 3 days??

Thank You