how to convert number of days to months
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
|