James bolton
Member
Hi,
I have attached a spreadsheet, I am trying to create stats of how many job items we received or prepared in a month/week.
That data worksheet shows all the date's entered into the received or prepared a job, these are extracted from our system. I've created a summary worksheet where I have listed all the months and weeks we will be working on these jobs, and I just wanted to create a formula to show, how many jobs we "prepared" or "received" (as from the data tab) within that month, or within that week (within 7 days before the week date)
Any help would be much appreciated.
Thanks
OB
I have attached a spreadsheet, I am trying to create stats of how many job items we received or prepared in a month/week.
That data worksheet shows all the date's entered into the received or prepared a job, these are extracted from our system. I've created a summary worksheet where I have listed all the months and weeks we will be working on these jobs, and I just wanted to create a formula to show, how many jobs we "prepared" or "received" (as from the data tab) within that month, or within that week (within 7 days before the week date)
Any help would be much appreciated.
Thanks
OB