+ Reply to Thread
Results 1 to 2 of 2

converting months to years and months???

Hybrid View

  1. #1
    Marty
    Guest

    converting months to years and months???

    I have used the following formula to work out the difference between two days
    and it provides me an answer in months.
    =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    However if the difference is 15 months, how do i convert this to read 1 year
    and 3 months?
    Thank you

  2. #2
    Dave Peterson
    Guest

    Re: converting months to years and months???

    With the date in A2:
    =DATEDIF(A1,a2,"y")&" Years "&DATEDIF(A1,a2,"ym")&" Months"

    You can find lots of information about =datedif() at Chip Pearson's site:
    http://www.cpearson.com/excel/datedif.htm

    Marty wrote:
    >
    > I have used the following formula to work out the difference between two days
    > and it provides me an answer in months.
    > =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    > However if the difference is 15 months, how do i convert this to read 1 year
    > and 3 months?
    > Thank you


    --

    Dave Peterson

+ 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