how to convert number of days to months

Ranjita Samyal Ranjita Samyal is offline

Junior Member

Posts: 1

Quote:

Originally Posted by Kevin B

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

Thank you. It was helpful- Ranjita

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert number of days into years/months	eileenmole	Excel Discussion (Misc queries)	2	April 17th 23 07:00 PM
How to convert a number to years, months, days?	Biz	Excel Worksheet Functions	3	February 10th 08 09:54 PM
how do i convert a number of days to years, months & days?	SafetyLen	Excel Discussion (Misc queries)	1	August 23rd 07 01:34 AM
How do I convert a number into Years, Months, Days format?	K. Krishna Murthi	Excel Worksheet Functions	6	December 24th 06 01:29 PM
how do I convert a number to number of years, months and days	because	Excel Worksheet Functions	2	October 12th 05 06:15 PM

All times are GMT +1. The time now is 07:13 AM.

Menu

About Us