View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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