+ Reply to Thread
Results 1 to 4 of 4

converting days to months

  1. #1
    Julie
    Guest

    converting days to months

    I was able to convert start date and and end date to the number of days
    inbetween the two dates. Does anyone know how to then convert the number of
    days into months?

  2. #2
    Rob van Gelder
    Guest

    Re: converting days to months

    Try:
    =MONTH(A2) - MONTH(A1)

    Or:
    =MONTH(A2) - MONTH(A1) + IF(DAY(A2)>DAY(A1), 1, 0)

    --
    Rob van Gelder - http://www.vangelder.co.nz/excel


    "Julie" <Julie@discussions.microsoft.com> wrote in message
    news:EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com...
    >I was able to convert start date and and end date to the number of days
    > inbetween the two dates. Does anyone know how to then convert the number
    > of
    > days into months?




  3. #3
    JE McGimpsey
    Guest

    Re: converting days to months

    One way:

    =DATEDIF(<start date>,<end date>,"m")

    See

    http://cpearson.com/excel/datedif.htm



    In article <EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com>,
    "Julie" <Julie@discussions.microsoft.com> wrote:

    > I was able to convert start date and and end date to the number of days
    > inbetween the two dates. Does anyone know how to then convert the number of
    > days into months?


  4. #4
    Harald Staff
    Guest

    Re: converting days to months

    Hi

    Use Datedif to find number of months between two dates:
    =DATEDIF(A1,B1,"m")
    And you know of course that 28 days may or may not be a whole month, so this
    is not a very precise way to measure time.

    HTH. Best wishes Harald

    "Julie" <Julie@discussions.microsoft.com> skrev i melding
    news:EB621787-DD1B-450A-9FB8-429C5A9813FB@microsoft.com...
    > I was able to convert start date and and end date to the number of days
    > inbetween the two dates. Does anyone know how to then convert the number

    of
    > days into months?




+ 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