Assign work-item to the person who did a particular work long ago among a team.

[mukuljain99]

If there are 5 people who handle a workitem, I want a formula to allot a workitem to the person who did that work item long back.
This will ensure that the particular workitem circulates to all team members and not just a selected few doing that workitem everyday.

Attaching excel file for reference.

EDIT:
The formula should study the previous week in case some agent has not been given that workitem in the previous week, he should not be given that item.

[DavidBowman]

EDIT:
The formula should study the previous week in case some agent has not been given that workitem in the previous week, he should not be given that item.

Are you sure you mean NOT. If so doesn't that mean that the solution is the schedule is the same every week. Just pickup what that person did on that day last week which would be the oldest one the person would be allowed to do.

[Logit]

.
I suppose you could use a formula for the following to accomplish your goal ... but actually it is simply a matter of setting up the first week for all of the employees,
then COPY / PASTE that data to the next X Days :

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		10/27/2019	10/28/2019	10/29/2019	10/30/2019	10/31/2019	11/1/2019	11/2/2019	11/3/2019	11/4/2019	11/5/2019	11/6/2019	11/7/2019
2	Agent Name	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday
3	a	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6
4	b	workitem2	workitem3	workitem4	workitem5	workitem6	Workitem1	workitem2	workitem3	workitem4	workitem5	workitem6	Workitem1
5	c	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2
6	d	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3
7	e	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4
8	f	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5	Workitem6	Workitem1	Workitem2	Workitem3	Workitem4	Workitem5

[JeteMc]

As for a formula proposal:
Manually populate B3:B8 as shown in the file attached to post #1
Put the following into cell C3: =B8
Put the following into cell C4 and drag the fill handle down to C8: =B3
Select C3:C8 and drag the fill handle over to cell N8.
Let us know if you have any questions.