Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert number of days to months
Greeting,
I have 63 days, the Question is How to convert it to 2 months and 3 days?? Thank You |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert number of days to months
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. "Jon" wrote: Greeting, I have 63 days, the Question is How to convert it to 2 months and 3 days?? Thank You |
#5
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number of days into years/months | Excel Discussion (Misc queries) | |||
How to convert a number to years, months, days? | Excel Worksheet Functions | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
How do I convert a number into Years, Months, Days format? | Excel Worksheet Functions | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions |