Formula to figure out count based on category week i'm in and for previous week and current week to date

polska2180

Active Member
Joined
Oct 1, 2004
Messages
384
Office Version
  1. 365
Hi I have a

column A that has week ie 2019.26 represent 26 week of the calendar day.

Column B Date

Column D Reason Code WH BD HOS...

Assuming my week is Mon to Sat (no data on Sunday)

I would like to have a formula that would go to B2 that knows what today is and tells me how many "WH" are in column D:D based on the date i have in column B from last week.

in D2 it would do the same but week to date or current week so far

F2 - Previous month

H2 - Month to date

Thank you
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Maybe I can explain this better basically i'm looking for effectively is a vlookup for a code WH as an example but I want to be able to tell how many times the code came up last week. In another cell I want to be able to see how many times week to date that code came up. Basically both cells would auto update each time the spreadsheet is open.

Thanks.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top