Results 1 to 18 of 18

dates overlap dynamic

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    8

    dates overlap dynamic

    I need to calculate leaves (X, Y ) during a specified task by an employee.


    Task Workdays
    Start (Column D ) << >> End (Column E ) ------ Leaves days (column F )
    1 10/10/2015 <<>> 11/15/2015 ---- X
    2 11/27/2015 <<>> 12/27/2015 ---- Y
    3. task3 (Start dt. <<>> End Dt. ) ------ Z
    4. task4
    5..... 2/5/2016 2/5/2015....


    The leaves /Period :
    Leaves
    Column G << >> Column H
    Start <<>> End
    10/4/2015 <<>> 10/10/2015
    11/10/2015 <<>>11/13/2015
    12/2/2015 <<>> 12/8/2015
    2/24/2015<<>> 1/1/2016
    2/5/2016 <<>> 2/5/2015
    and so on.......

    The task list will be ever increasing, and so will be the leaves .

    i need to find leaves taken during the the task 1 (X ) , similarly for task 2 (Y )
    the leaves table will be say 200 rows to start with and gradually scalable, same with task list
    also need to account workdays only (remove week ends )
    Attached Files Attached Files
    Last edited by shishm; 12-23-2015 at 05:01 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting rule to see if any booking dates overlap
    By lawrencef in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2015, 01:08 AM
  2. [SOLVED] Count Start and End Dates that Overlap Specified Date Range
    By DigDoug in forum Excel General
    Replies: 8
    Last Post: 06-11-2014, 09:46 AM
  3. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  4. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  5. Find duplicate / overlap (-ping) dates in data
    By samcdavies in forum Excel General
    Replies: 4
    Last Post: 06-23-2012, 06:54 AM
  6. Conditional Formatting with Dates:overlap
    By Thayin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2009, 01:18 AM
  7. Calculate Total Time when Dates/Times Overlap
    By Steve Gilley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2008, 07:43 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