Good morning, everyone. First time to this site and first time poster (I normally use MS Office's Discussion Groups but they are down for some reason.) I have a problem that I am trying to figure out and for the life of me I can't.
Situation is as follows:
2 sheets, one is dB_File and the other is Sheet_2
On Sheet_2, I have a reporting period date listed in cell G1, formatted mm/dd/yyyy, and the employee number in cell G13.
On dB_File, I have a list of sales, with all the details of the particular sales. Column B has the employee number associated with a particular sale. Column BQ has the date that the sale was made.
Back to Sheet_2, in cell G17, I am trying to count the number of sales an employee made in a particular MONTH. But I don't know how to structure my countifs criteria so that it counts all sales made in a month, not just a day. Here is what I have so far.
I want this particular cell to count all of the sales made 3 months before the current reporting period. So, if I am working on April's reporting period, I want to know all of the sales made during the month of January. Any help would be greatly appreciated.HTML Code:
Bookmarks