Greetings,
In my spreadsheet, each row represents a specific event, with the columns having data about the events. I have a column for "Start date of Event" and a column for "End date of Event". The cells in these columns have simple dates in them. What I am hoping to do is identify if there is ever a duration of greater than a set number of days (60 days) between the "End date" of one event and the "Start date" of another event. The tricky parts are that some of these events overlap and they don't have set durations. Does anyone have any idea if this is possible? Please let me know if I can explain this further. Thank you!
In my spreadsheet, each row represents a specific event, with the columns having data about the events. I have a column for "Start date of Event" and a column for "End date of Event". The cells in these columns have simple dates in them. What I am hoping to do is identify if there is ever a duration of greater than a set number of days (60 days) between the "End date" of one event and the "Start date" of another event. The tricky parts are that some of these events overlap and they don't have set durations. Does anyone have any idea if this is possible? Please let me know if I can explain this further. Thank you!