Comparing column of data within the same column

  • I have 2 columns. And I need to test whether or not the maintenance date of one aircraft overlaps the date of another aircraft by +/- 180 days. The main parameter being...i cannot have more than 5 aircraft in a maintenance period at once.


    Started learning VBA about a month ago for work. I have the basics down, but I just don't really have a good grasp on tackling this problem. Any guidance would be appreciated