Pulling date information between two dates

I have two sheets. One has an increase start date and the date of that person's performance review. The other sheet has the salary effective date and a date range. I want to pull the salary effective date from the reference sheet to the main sheet where it says increase start date based off what date their performance review date is. For example, If someone's performance review is on 6/16 then I want to pull 6/19 into the main sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!