Date using index/collect if between X and Y on another sheet

Options

Hello, Community! I'm trying to pull in the Return_Date value from the Dates sheet where the Earnings End Date on the Additional Pay sheet is between the Start and End date ranges on the Dates sheet but am getting an #INCORRECT ARGUMENT SET error and not sure why. Any thoughts or alternatives? Thanks, all!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!