WEEKLY COUNT

Marilen.Navarro103391

Hello,

I need to create a report showing weekly "BOOKED" per category and associate. Weekly is from M-F.

My sheet looks like this below:

Thank you so much.

Marilen.Navarro103391

@Paul Newcome Good Morning!

I'd like to do this weekly, so I guess that means multiple.

Paul Newcome

Ok. You would use the same COUNTIFS, but you would adjust the dates that are in bold. The first date is the Monday and the second date is the Friday.

=COUNTIFS({Pattern Sheet Worker Column}, "LUIS", {Pattern Sheet Status Column}, "BOOKED", {Pattern Sheet Date Completed Column}, AND(@cell >= DATE(2020, 07, 27), @cell <= DATE(2020, 07, 31)))

The dates are (yyyy, mm, dd)

Paul Newcome

Is the category listed anywhere on the sheet in the second screenshot?

Marilen.Navarro103391

@Paul Newcome

Hi Paul,

Yes, the category is per sheet.

Paul Newcome

Then (using the appropriate steps to create cross sheet references) you will want to use a formula similar to...

=COUNTIFS({Pattern Sheet Worker Column}, "LUIS", {Pattern Sheet Status Column}, "BOOKED", {Pattern Sheet Date Completed Column}, AND(@cell >= DATE(2020, 07, 27), @cell <= DATE(2020, 07, 31)))

That will give you the count for the specific week of this Monday (27 July) through this Friday(31 July).

If you needed something different, feel free to let me know.

Marilen.Navarro103391

This is great. I got it @Paul Newcome

Is there another formula you can help, I would like to have it automatically every week? I want to show the Dashboard, daily output per week.

Paul Newcome

Are you looking for the current week, or are you wanting to display multiple weeks?

Marilen.Navarro103391

@Paul Newcome Good Morning!

I'd like to do this weekly, so I guess that means multiple.

Paul Newcome

Ok. You would use the same COUNTIFS, but you would adjust the dates that are in bold. The first date is the Monday and the second date is the Friday.

=COUNTIFS({Pattern Sheet Worker Column}, "LUIS", {Pattern Sheet Status Column}, "BOOKED", {Pattern Sheet Date Completed Column}, AND(@cell >= DATE(2020, 07, 27), @cell <= DATE(2020, 07, 31)))

The dates are (yyyy, mm, dd)