Display Current Week # according to range.

[lxa8888]

Here is my challenge:

On the Season Info tab of the attached spreadsheet I want the Yellow cell to display the week number corresponding with the date range on the data tab.

Using today's date (found on the Season Tab) I want excel to check and see if today's date falls between one of the date ranges on the data tab and if it does then I want cell C21 (yellow cell on Season info sheet) to display the number in the # week column on the Data Sheet.

Please help.

If today's date (green cell) falls between a date range on the data sheet then display Week # found in same row as date range on data sheet into the yellow cell on the Season Info Sheet