Hi, I am trying to convert the daily date to bi-weekly on a spreadsheet that is using =IMPORTRANGE from another workbook.

I am building this on a new sheet that refers to the sheet with =IMPORTRANGE. I also would like to have the data show in a line chart.

Data Example:

Food Date
Apple 1/3/16
Apple 1/5/16
Carrot 1/10/16
Carrot 5/4/16
Apple 5/12/16
Carrot 12/2/16

The Result:

Week 1 and 2
Food Count
Apple 2
Carrot 1

Week 19 and 20
Food Count
Apple 1
Carrot 1

Week 51 and 52
Food Count
Carrot 1


How do I get this?