Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Identifying Overlapping Dates within a range
I'm currently trying to figure out how - and IF - Excel has a function that
will identify overlapping dates when only the Start and End Date is provided. Basicallly, the sheet has 12 areas that we can enter previous work experience, and we enter the Start and End date. What I need to figure out, is how to make the spreadsheet identify dates from the 12 ranges and exclude all overlapping months. For example: I have one date range from March 2003 to May 2004, a second from January 2002 to May 2003, and a third from February 2004 to May 2005. I need to find a way to automatically identify that March-until-May 2003 there's an overlap, and from February-until-May 2004 there's an overlap. 2 questions really: Can this be done? And, if so, how or using what function? Thanks in advance |
#2
|
|||
|
|||
Hi!
Can this be done? And, if so, how or using what function? Yes, it can be done but it's not a very elegant solution. It's not very complicated, however, trying to explain all the steps necessary without causing mass confusion is probably impossible. If you want to contact me I'll send you a sample file that does what you want. I'm at: xl "can" help at comcast period net Get rid of the quoted stuff and change the obvious. Biff "Tremain" wrote in message ... I'm currently trying to figure out how - and IF - Excel has a function that will identify overlapping dates when only the Start and End Date is provided. Basicallly, the sheet has 12 areas that we can enter previous work experience, and we enter the Start and End date. What I need to figure out, is how to make the spreadsheet identify dates from the 12 ranges and exclude all overlapping months. For example: I have one date range from March 2003 to May 2004, a second from January 2002 to May 2003, and a third from February 2004 to May 2005. I need to find a way to automatically identify that March-until-May 2003 there's an overlap, and from February-until-May 2004 there's an overlap. 2 questions really: Can this be done? And, if so, how or using what function? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Find (Today-21) in a range of dates | Excel Discussion (Misc queries) | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Sum between a range of dates | Excel Worksheet Functions |