Excel Formula help, IFS function

I am trying to write an IFS statement to determine if a date falls within a certain date range.   Date Range: is in Sheet 2 (see below)   A B C 1 FY18 7/1/2017 6/30/2018 2 FY19 7/...