If date is within a table of multiple date ranges return a value also in that table

Example data   Start date       End date       Fiscal year 8/1/2009 7/31/2010 2010 8/1/2010 7/31/2011 2011 8/1/2011 7/31/2012 2012 8/1/2012 7/31/2013 2013   I want to be a...