convert number of days into years/months

's Computer Specifications

How do I convert a number of days (example 395) into years:months (Example
1:1)? Thanks!

's Computer Specifications

That depends on your starting date (for the months anyway). Some months have
31 days, some 30... Did you want to assume a 30 day month or did you want to
supply a starting date.

If you are supplying a starting date then you could sue DateDif. Check out
this link...
http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson

"eileenmole" wrote:

> How do I convert a number of days (example 395) into years:months (Example
> 1:1)? Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert a number to years, months, days?	Biz	Microsoft Excel Worksheet Functions	3	10th Feb 2008 09:54 PM
how do i convert a number of days to years, months & days?	=?Utf-8?B?U2FmZXR5TGVu?=	Microsoft Excel Misc	1	23rd Aug 2007 01:34 AM
How do I convert a number into Years, Months, Days format?	=?Utf-8?B?Sy4gS3Jpc2huYSBNdXJ0aGk=?=	Microsoft Excel Worksheet Functions	6	24th Dec 2006 01:29 PM
Convert Years to Years/Months/Days	coreymartin@gmail.com	Microsoft Excel Discussion	4	4th Jan 2006 02:58 PM
how do I convert a number to number of years, months and days	=?Utf-8?B?YmVjYXVzZQ==?=	Microsoft Excel Worksheet Functions	2	12th Oct 2005 06:15 PM