Find same date

I have an employee request for time off sheet. One column has the date the employee has requested off, another has the date the employee is set to return to work and a third column is "Other Employees off at the same time." Is there a formula that will search the entire sheet of dates of leave and dates of return to let me know who else is going to be off during that same time frame?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!