Coverting Yrs. into Mos.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

edbyrd

Thread Starter
Joined
Jul 12, 2003
Messages
19
I need to convert the months into years so that it places the number of whole years into one cell and the number of odd/fractional months (that are left over and don't make a year) in another cell beside it. Example: 250 months is 20.83 years, but I need it to show 20 (yrs. in one cell) and 10 (the remainder of months) in another. Help would be appreciated.
 
Joined
Jul 25, 2001
Messages
377
In A1 enter the no of months, eg. 250
in B1 (for example) enter =int(sum(A1/12))
in C1 enter =mod(A1,12)

hope this helps
 
Joined
Feb 24, 2003
Messages
331
Here's another way with 12/1/1982 in cell A1

In B1 =DATEDIF(A1,TODAY(),"Y")
In C1 =DATEDIF(A1,TODAY(),"YM")
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top