Brandon Carraway
New Member
I'm stumped... I can usually figure this stuff out, but this I just can't.
I have a list of associates with dates, and if I get a certain number of items within a work week, I want excel to flag the full week. The kicker, is that weeks change every month.
I attached my SS; I also entered a row below associate's row in case a formula is required (which I can hide once I'm done).
Any help would be greatly appreciated, even if it's a nudge in the correct direction.
UPDATE:
What I am trying to get done, is this:
Week start is 07/01/17.
Week end is 07/07/17.
If an associate turns in 4 items within that week, the whole week gets flagged.
Week start is always Saturday, week end is always Friday.
I also JUST uploaded an updated SS; the dates were wrong. XD
I have a list of associates with dates, and if I get a certain number of items within a work week, I want excel to flag the full week. The kicker, is that weeks change every month.
I attached my SS; I also entered a row below associate's row in case a formula is required (which I can hide once I'm done).
Any help would be greatly appreciated, even if it's a nudge in the correct direction.
UPDATE:
What I am trying to get done, is this:
Week start is 07/01/17.
Week end is 07/07/17.
If an associate turns in 4 items within that week, the whole week gets flagged.
Week start is always Saturday, week end is always Friday.
I also JUST uploaded an updated SS; the dates were wrong. XD
Last edited:
