How do I convert a number of days (example 395) into years:months (Example 1:1)? Thanks!
E eileenmole Sep 6, 2007 #1 How do I convert a number of days (example 395) into years:months (Example 1:1)? Thanks!
J Jim Thomlinson Sep 6, 2007 #2 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
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
