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?
Bookmarks