Thread: how to convert number of days to months
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
  
Posts: 208
Default how to convert number of days to months
Assuming your date is in A1...

=TRUNC(A1/30,0)&" Months and "&MOD(A1,30)&" days"


On May 23, 9:22 am, Jon wrote:
Greeting,

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

Thank You

Reply With QuoteReply With Quote