I've tried the formula above but keep getting the return of "FALSE"
I've come up with the array formula below but need to add in an additional function to limit the results to match back to $C2. Any thoughts?
=MIN(IF('Worksheet 1'!C:C>=TODAY(),'Worksheet 1'!C:C,""))
Bookmarks