Date Range Conflict - Vacation Request Sheet

Hello,

I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me.

Form requests will populate new rows of all time off requests.

Before approving it, need a quick way to determine if there is date overlap with another request. See request for Employee X and Y.

Start and Finish are regular Date fields, just with changed formatting.


Thanks a lot!



Best Answers

«134

Answers