Results 1 to 7 of 7

Excel Formula/Function to find total number of non-overlapping months

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2007
    Posts
    67

    Excel Formula/Function to find total number of non-overlapping months

    Hi Guys, good day to you all. I have 10 projects, each with a start and an end date. I need to find the number of months in between each project's start date and end date without counting overlapping months. For example;

    Project one, I count three months from Jan 2015 - Mar 2015
    If project two runs from Jan 2015 - Jun 2015, I wont be counting 6 months but 3 months as I wont count the overlapping months.

    I have attached an excel which has a sample data.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Please help to Find the last 6 Months Total Qty from Monthly Data (SUMPRODUCT FUNCTION)
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2015, 05:44 AM
  2. Replies: 2
    Last Post: 07-22-2014, 02:15 AM
  3. [SOLVED] Formula to Find Total Number of Different Value Variations
    By artiststevens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2014, 04:04 PM
  4. [SOLVED] Use Function to find total number of times a word is used on multiple worksheets.......
    By rufiotgl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2013, 10:52 AM
  5. Replies: 0
    Last Post: 07-30-2012, 04:51 PM
  6. [SOLVED] function string to find non-overlapping ranges of values
    By carbonboywonder in forum Excel General
    Replies: 13
    Last Post: 05-01-2012, 03:59 PM
  7. a formula to find total compound amount after given number of yea.
    By ronan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2005, 05:06 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