Checking if a date falls within a range


Hi, I've seen a few answers on this forum that addressed similar questions to my own but I can't seem to make those solutions work for me so I thought I would ask again 😁

I have a time off request form populating a worksheet and I'd like the worksheet to automatically calculate if a time off request falls within 3 business days of a company holiday.

So here's my source worksheet, populated by the form:

And here's my helper sheet with holiday info; I used WORKDAY for the start and end ranges.

So I'm not sure how to marry this up and see if either the Start Date or the End Date from my source worksheet fall within the Start Range and/or End Range from the holiday info helper sheet and then populate Y or N in the Holiday Warning column of the source sheet. Your advice would be much appreciated!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!