1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Coverting Yrs. into Mos.

Discussion in 'Business Applications' started by edbyrd, Oct 4, 2003.

Thread Status:
Not open for further replies.
  1. edbyrd

    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.
     
  2. mrwendal

    mrwendal

    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
     
  3. maxflia10

    maxflia10

    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")
     
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/169535

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice