Pulling date information between two dates

Smartersheet user 22

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.

Paul Newcome

Try something like this:

=MIN(COLLECT({Dates To Pull}, {Dates To Pull}, @cell>= [Performance Review]@row))