+ Reply to Thread
Results 1 to 2 of 2

Confused about checking for overlap of dates for multiple subcontractors/employees

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Maryland, USA
    MS-Off Ver
    2010
    Posts
    1

    Question Confused about checking for overlap of dates for multiple subcontractors/employees

    Hi all

    I'm trying to make a scheduling calendar for my general contractor business, but I think I've been thinking about it too hard. I am incredibly confused.

    I have a handful of projects going simultaneously, and I have a handful of subcontractors working for me on these projects. They can't work on more than one project at a time. I am trying to schedule them without any overlap, but I can't figure it out.

    I have five subcontractors: HVAC, plumbing, electric, drywall, and roofing. They can all work on the same project simultaneously, no problem. But any one subcontractor can't work on more than one project per day, and they always finish one project before moving to another. So I need to be able to enter a start date, an end date, which project it is, which subcontractor it is, and then have Excel tell me if I have any of the subcontractors in more than one place on any given day so I can adjust accordingly. I'll then use this info to manually fill in the calendars around the office.

    Thank you, and I hope this makes sense. It's been a long day.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Confused about checking for overlap of dates for multiple subcontractors/employees

    I'm probably way oversimplifying, but if you have the dates in rows and the subcontractors in columns, it wouldn't be possible to have a subcontractor entered more than once on the same day because there's only one cell available.

    Schedule.PNG
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ 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. Checking if employees have completed trainings? Vlookup, countifs, ... ?
    By begexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2014, 05:47 PM
  2. Date + time overlap checking
    By zRc55 in forum Excel General
    Replies: 21
    Last Post: 09-27-2013, 01:34 AM
  3. [SOLVED] Cross-checking list to determine overlap of entries
    By rhodesp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2013, 03:52 PM
  4. [SOLVED] Macro executes but not giving results :confused::confused::confused:
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 10:49 AM
  5. Replies: 9
    Last Post: 03-05-2012, 08:17 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