Current Week vacation formula

What did I mess up in my formula to calculate from another sheet, the number of drivers taking vacation in the current week for my dashboard?

=COUNTIFS({Vacation Intake Sheet Range 1}, "<=" & (TODAY() - WEEKDAY(TODAY(), 1) + 7), {Vacation Intake Sheet Range 4}, ">=" & (TODAY() - WEEKDAY(TODAY(), 1) + 1))

For context, the intake sheet has columns DRIVER, REQUEST, START DATE, END DATE

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!