+ Reply to Thread
Results 1 to 3 of 3

How to calculate number of months by date range for a specific year?

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2011
    Posts
    9

    How to calculate number of months by date range for a specific year?

    Hello,

    Hoping someone can help me with this.

    I have date ranges for contracts similar to below:

    Column G / Column H / Column O
    Start Date / End Date / Payment amount
    2006-04-01 / 2010-04-01 / 577.9700
    2011-12-15 / 2014-12-15 / 407.61


    I'm using pivot table to report on a bunch of the information, one of which would be something similar to:

    How much money was collected in 2010, 2011, 2012, 2013, 2014, 2015

    I'm not sure how to extrapolate that data from the date ranges. In the above example, if we were looking at 2014, then it should end up being 12*407.61 since they were charged 12 times in 2014.

    I have hundreds of contracts to sort through, is there an easy way of doing this?


    Thanks!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: How to calculate number of months by date range for a specific year?

    smth like that
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-24-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2011
    Posts
    9

    Re: How to calculate number of months by date range for a specific year?

    Thanks!

    I used your formula and tweaked it a bit for my formatting but it's doing exactly what i need.

    Hope you have a great weekend!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate number of months in a specific year between two dates.
    By chickynee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-09-2019, 07:29 PM
  2. Extracting number of months from date range based on specific criterea
    By trianglehead in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2013, 07:27 PM
  3. Calculate number of months in year
    By littlelax in forum Excel General
    Replies: 9
    Last Post: 02-02-2012, 09:01 AM
  4. Replies: 3
    Last Post: 03-12-2009, 09:54 AM
  5. Replies: 5
    Last Post: 06-07-2008, 02:32 PM

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