+ Reply to Thread
Results 1 to 5 of 5

Convert months to months and years

Hybrid View

  1. #1
    Registered User
    Join Date
    08-16-2004
    Posts
    34

    Convert months to months and years

    in cell A1 i have a number of months. What I want to do is convert this into years and months.

    ie 14 = 1 year 2 months.

    Any help would be appreciated.

    Cheers

  2. #2
    Registered User
    Join Date
    09-06-2006
    Location
    Italy
    Posts
    11
    Quote Originally Posted by teeb
    in cell A1 i have a number of months. What I want to do is convert this into years and months.

    ie 14 = 1 year 2 months.

    Any help would be appreciated.

    Cheers
    Do you need it as a macro which implements 2 cells (say, Years=A2 and Months=A3) or as a couple of cells in which are directly shown the equivalent numers of years and months?

  3. #3
    Registered User
    Join Date
    08-16-2004
    Posts
    34
    Quote Originally Posted by Alfry
    Do you need it as a macro which implements 2 cells (say, Years=A2 and Months=A3) or as a couple of cells in which are directly shown the equivalent numers of years and months?
    Ideally the result would be in one cell but evern if i had two cells with the number of years and another with the number of months I could join them together

  4. #4
    Registered User
    Join Date
    09-06-2006
    Location
    Italy
    Posts
    11
    Quote Originally Posted by teeb
    Ideally the result would be in one cell but evern if i had two cells with the number of years and another with the number of months I could join them together
    In this case Carim's post fits your needs better .
    Last edited by Alfry; 01-22-2007 at 12:48 PM.

  5. #5
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    =INT(A1/12)&" year "&MOD(A1,12)&" months "
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1