+ Reply to Thread
Results 1 to 3 of 3

Overlapping tasks periods

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    Portugal
    MS-Off Ver
    2010
    Posts
    49

    Overlapping tasks periods

    I come again to ask for help for the following problem:

    - I have a set of tasks that have a start date for the task and an end date for the task;

    - For this set of tasks I needed to know, by VBA, in an orderly way, which periods (date range) where there are more overlapping tasks;

    - In a first stage, the ordering of the data will be made, for the largest number of overlaps and within those of the one with the greatest overlapping days, that is, for periods with the same number of overlaps, the first is what has more days.

    I say that it is in a first phase since in fact the ordering will be done by calculating a new "WEIGHT" that will be equal to WEIGHT = A1 * D1 * A1 / 3, and the ordering will be from the highest to the lowest WEIGHT, as you can see in the data on the right in the “OUTPUT” tab.

    In the file I attach, I have a set of data, tasks and dates, and the expected results, number of overlapping tasks, date range and number of days.

    All help will be welcome
    Jorge Cabral

    PS: Also in https://www.ozgrid.com/forum/index.p...periods-dates/
    Attached Files Attached Files
    Last edited by JCabral; 01-21-2020 at 09:06 AM.

  2. #2
    Registered User
    Join Date
    11-04-2014
    Location
    Portugal
    MS-Off Ver
    2010
    Posts
    49

    Re: Overlapping tasks periods

    Any help will be very welcome.

    Thanks
    Jorge Cabral
    Last edited by JCabral; 01-30-2020 at 07:41 PM.

  3. #3
    Registered User
    Join Date
    11-04-2014
    Location
    Portugal
    MS-Off Ver
    2010
    Posts
    49

    Re: Overlapping tasks periods

    Any tip on this?

    Thanks
    Jorge Cabral

+ 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. Help with total number of days overlapping in two periods
    By hweld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2019, 12:16 PM
  2. [SOLVED] Finding overlapping date periods for specific variables
    By pickaside in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2019, 10:00 AM
  3. [SOLVED] Lookup tasks and sort by date and exclude completed tasks
    By AlexSchmidt in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-19-2017, 04:47 PM
  4. Overlapping Times (in daily tasks)
    By blp_ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2014, 02:24 PM
  5. Replies: 0
    Last Post: 07-30-2012, 04:51 PM
  6. Merging Tasks w/ Parts ordered for tasks
    By code870 in forum Excel General
    Replies: 0
    Last Post: 06-19-2011, 01:43 PM
  7. Outlook Tasks - Adding tasks from a worksheet added today or after
    By dpotta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2010, 07:15 AM

Tags for this Thread

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