Hello:

I'm new so I hope that this has not been posted. I have a spreadsheet that I use to track vacations. Dates are listed across the top, and in column A all the names of people. I am looking for a formula that will quickly help me find all the rows where vacation dates overlapp...i.e. for person one they have values in the cells B4:F4 indicating vacation. I want a formula that will identify overlap i.e. B15:F15. Ideally, when overlapps are found it will show the values in A column (i.e. show me the names of the people where there is overlapp).

If anyone could help me out it would be very much appreciated.

Thanks,

Alex