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
Bookmarks