How to find the minimum and maximum values within a specified set ... same year is equal to or less than the End date in D2, this function returns TRUE and FALSE if not. In Figure B, you can ...