Greeting, I have 63 days, the Question is How to convert it to 2 months and 3 days?? Thank You
J Jon May 23, 2008 #1 Greeting, I have 63 days, the Question is How to convert it to 2 months and 3 days?? Thank You
K Kevin B May 23, 2008 #2 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")
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")
T Tim879 May 23, 2008 #3 Assuming your date is in A1... =TRUNC(A1/30,0)&" Months and "&MOD(A1,30)&" days"
A AnotherNewGuy May 23, 2008 #4 However, it's very rare for two consecutive months ever to total 60 days. I'm not intending to belabor the obvious -- just wondering if that's really what you want to do.
However, it's very rare for two consecutive months ever to total 60 days. I'm not intending to belabor the obvious -- just wondering if that's really what you want to do.
