Determining if a date is between certain periods

Our accounting year is not Jan to Dec but May to April. I have a table with a list of dates and I need to determine which period each month is as well as which Financial Year the date is for.   For...