Search for periods longer than 28 days from multiple date ranges (plz help)

I searched, but I didn't find what I'm looking for. If it's already been discussed in this forum, please point me where I should go.

I have a table with the Event Description, Start Date and End Date columns.

I need to identify all intervals greater than 28 days.

The most tricky part is that dates can overlap, for example:

Event01 from 01/01/2000 to 31/01/2000
Event02 from 15/01/2000 to 10/02/2000
(9 days interval)
Event03 from 20/02/2000 to 30/03/2000
(>28 days interval, and must be flagged as an interval greater than 28 days between dates 30/03/2000 and 01/06/2000)
Event04 from 01/06/2000 to 10/06/2000
Event05 from 05/06/2000 to 30/06/2000


I have hundreds of rows with date ranges and I can't find a way to run a validation through them all.

Can you help me, please?

And I'm assuming that an "Interval" is the # of days between 1 event and another, NOT the # of days of the event itself.

When you attach a good sample workbook, please remember to include EXPECTED ANSWERS.

I apologize if I didn't explain myself well.

No, the information is not all contained in a single cell.
Column A - Event Description
Column B - Start Date
Column C - End Date

I've no ideas to get this working properly. I thought about using days360 formula, but there are things that won't work.

Thought getting previous EndDate and next StartDate with days360, could fix my issue, if negative or less or iqual than 28 it was OK, if not nOK.

This is for security background check... With responsabilities in HR, I need to check a couple hundred people if they have, in the last 5 years, an interval greater than 28 days between their academic/tranning activities and professional experience. These intervals need to be declared and explained.

For each one, I need to create a document listing all academic activities (or similar) and professional experience. In case of inspection from the proper authority, this need to be done flawlessly. If done all manually, i'll get insane with thousands of documents to analise and crosscheck... The ammount of time spent...

My problem is, for example, if they have a job for, lets say, 3 years and have, in the same period, some training or academic activities, days360 won't help. It could flag more than 28 days in training/academic, but the job will cover those 28 days.

It's too dificult to sort them all manually and I already have all information in a workbook, just need to fix this issue.

Somehow I need to overlay all dates as a timeline and look for "holes" greater than 28 days. I can't visualize how to do it in Excel nor find some similar example that point me the right direction.

Thank you for your time looking at this.