Home |
Search |
Today's Posts |
#1
|
|||
|
|||
overlapping date ranges
Hi,
I am new to the forum! my friends talk a lot about this and glad to be in the forum using Office 2007. My question--- I work in a manufacturing company which makes different sizes of Nuts on many machines. One machine can do only one size of Nuts for a particular period and can be molded for another variant.I manage an excel sheet defining the date ranges of the machine utility for a particular Nut, this allows us to mark our next point for another size. The problem is.. after fixing dates for a process on a machine, I many time loose track of the previous marked dates and issue new dates for the same machine that is usually overlapping and lately found out. Please help me with a solution ~~~ which does not allow overlapping of dates on a particular machine unless the previous dates alloted be changed. Machines Start date End date Machine 1 1/25/2011 2/7/2011 Machine 2 1/2/2011 1/25/2011 Machine 3 1/2/2011 1/25/2011 Machine 1 2/19/2011 3/22/2011 Machine 1 1/27/2011 2/11/2011 I use the Table feature of Excel 2007 for this data |
#2
|
|||
|
|||
My husband and I only overlap our vacations by a long weekend this year and I want to do something special as it is also a special anniversary. I've used expedia, orbitz, etc. to go to specific destinations but I am looking for where I can go but they all ask for a location.
|
#3
|
|||
|
|||
Quote:
=IF(SUMPRODUCT((B$2:B$6<=C2)*(C$2:C$6=B2))1,"Thi s range Overlaps","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine two sets of overlapping Date/Time data into 3 columns. | Excel Worksheet Functions | |||
How do I get a new calculated date from different date ranges? | Excel Worksheet Functions | |||
Number of days in overlapping date ranges (using array formula?) | Excel Worksheet Functions | |||
compare date to various date ranges and sum value | Excel Worksheet Functions | |||
Overlapping or Duplicate Date & Time | Excel Worksheet Functions |