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


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!