Spreadsheet is a record of missions performed over the past year. Column B is the date of missions, E is the length of the mission in hours (1.5, 2.7, 4.6 etc.)

I need to count the number of missions performed during the previous week (the previous Mon - Sun...not the previous 7 days) So today is Thursday Feb 24, I need to count the number of missions performed between Monday the 14th and Sunday the 20th.

I also need to sum the total mission hours (column E) during the previous week as well.

Any help is much appreciated.

Scott