how to convert number of days to months

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Greeting,

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

Thank You
 
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 date is in A1...

=TRUNC(A1/30,0)&" Months and "&MOD(A1,30)&" days"
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Number of Month to Number of days 4
converting days to years & months & days 4
how do i convert a number of days to years, months & days? 1
How to Convert MBOX to PST Online? 3
convert # of years, months and days 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Expanding Date formula 1
Hosting photos on own server: what are the pros and cons here? 0

Back
Top