Planning activities on difrent daye - but two only

[tenbellies]

Hi all,

I have a large spreadsheet with a seris of activites on the majority can be done the same day, however further down the process we can only do two each day.

So is there a formula that anyone knows that looks at a row of dates and then only allocates two activities on any one weekday, so it would look like this?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]01/10/18
[/TD]
[TD]02/10/18
[/TD]
[/TR]
[TR]
[TD]01/10/18
[/TD]
[TD]02/10/18
[/TD]
[/TR]
[TR]
[TD]01/10/18
[/TD]
[TD]03/10/18
[/TD]
[/TR]
[TR]
[TD]01/10/18
[/TD]
[TD]03/10/18
[/TD]
[/TR]
[TR]
[TD]02/10/18
[/TD]
[TD]04/10/18
[/TD]
[/TR]
[TR]
[TD]02/10/18
[/TD]
[TD]04/10/18
[/TD]
[/TR]
[TR]
[TD]03/10/18
[/TD]
[TD]05/10/18
[/TD]
[/TR]
[TR]
[TD]04/10/18
[/TD]
[TD]05/10/18
[/TD]
[/TR]
[TR]
[TD]04/10/18
[/TD]
[TD]08/10/18
[/TD]
[/TR]
[TR]
[TD]04/10/18
[/TD]
[TD]08/10/18
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Oscar Cronquist]

[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Dates1[/td][td]Dates2[/td][td][/td][td]Dates 2[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

1/10/2018​

[/td][td]

2/10/2018​

[/td][td][/td][td]

8/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

1/10/2018​

[/td][td]

2/10/2018​

[/td][td][/td][td]

8/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

1/10/2018​

[/td][td]

3/10/2018​

[/td][td][/td][td]

5/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

1/10/2018​

[/td][td]

3/10/2018​

[/td][td][/td][td]

2/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

2/10/2018​

[/td][td]

4/10/2018​

[/td][td][/td][td]

2/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

2/10/2018​

[/td][td]

4/10/2018​

[/td][td][/td][td]

4/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

3/10/2018​

[/td][td]

5/10/2018​

[/td][td][/td][td]

3/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

4/10/2018​

[/td][td]

5/10/2018​

[/td][td][/td][td]

4/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

4/10/2018​

[/td][td]

8/10/2018​

[/td][td][/td][td]

3/10/2018​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

4/10/2018​

[/td][td]

8/10/2018​

[/td][td][/td][td]

5/10/2018​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet63[/td][/tr][/table]

Array formula in cell B2:

=MIN(IF((COUNTIF($B$1:B1,$D$2:$D$11)<2)*(COUNTIF($D$2:$D$11,$D$2:$D$11)>COUNTIF($B$1:B1,$D$2:$D$11)),$D$2:$D$11,""))

Press and hold CTRL + SHIFT and then press Enter to create an array formula.