<table><tr><td></td><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr><tr><td>1</td><td bgcolor='#FFFFFF'>Formula</td><td bgcolor='#FFFFFF'>Inbetween</td><td bgcolor='#FFFFFF'>Projects</td><td bgcolor='#FFFFFF'>Clients</td><td bgcolor='#FFFFFF'>Date Start</td><td bgcolor='#FFFFFF'>Date End</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#50D092'>Between</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>2</td><td bgcolor='#FFFFFF'>=IF(AND(E2<=Between,F2>=Between),1,0)</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#50D092'>Project1.c1</td><td bgcolor='#50D092'>Client1</td><td bgcolor='#50D092'>1/04/2014</td><td bgcolor='#50D092'>5/09/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#9AD6C2'>5/09/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>3</td><td bgcolor='#FFFFFF'>=IF(AND(E4<=Between,F4>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project1.c2</td><td bgcolor='#9597D9'>Client2</td><td bgcolor='#9597D9'>2/11/2014</td><td bgcolor='#9597D9'>17/12/2014</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>4</td><td bgcolor='#FFFFFF'>=IF(AND(E7<=Between,F7>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project1.c3</td><td bgcolor='#9597D9'>Client3</td><td bgcolor='#9597D9'>28/09/2014</td><td bgcolor='#9597D9'>6/11/2014</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>5</td><td bgcolor='#FFFFFF'>=IF(AND(E10<=Between,F10>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project1.c4</td><td bgcolor='#9597D9'>Client4</td><td bgcolor='#9597D9'>6/12/2014</td><td bgcolor='#9597D9'>1/01/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#BCE4D7'>Clients</td><td bgcolor='#FFFFFF'>(All)</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>6</td><td bgcolor='#FFFFFF'>=IF(AND(E14<=Between,F14>=Between),1,0)</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#50D092'>Project1.c5</td><td bgcolor='#50D092'>Client5</td><td bgcolor='#50D092'>1/03/2014</td><td bgcolor='#50D092'>31/10/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#BCE4D7'>Inbetween</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>7</td><td bgcolor='#FFFFFF'>=IF(AND(E3<=Between,F3>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project2.c1</td><td bgcolor='#9597D9'>Client1</td><td bgcolor='#9597D9'>21/08/2014</td><td bgcolor='#9597D9'>4/09/2014</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>8</td><td bgcolor='#FFFFFF'>=IF(AND(E5<=Between,F5>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project2.c2</td><td bgcolor='#9597D9'>Client2</td><td bgcolor='#9597D9'>3/11/2014</td><td bgcolor='#9597D9'>20/12/2014</td><td bgcolor='#FFFFFF'></td><td bgcolor='#BCE4D7'>Projects</td><td bgcolor='#BCE4D7'>Date Start</td><td bgcolor='#BCE4D7'>Date End</td><td bgcolor='#BCE4D7'>Count of Projects</td></tr><tr><td>9</td><td bgcolor='#FFFFFF'>=IF(AND(E8<=Between,F8>=Between),1,0)</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#50D092'>Project2.c3</td><td bgcolor='#50D092'>Client3</td><td bgcolor='#50D092'>4/09/2015</td><td bgcolor='#50D092'>5/09/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Project1.c1</td><td bgcolor='#FFFFFF'>1/04/2014</td><td bgcolor='#FFFFFF'>5/09/2015</td><td bgcolor='#FFFFFF'>1</td></tr><tr><td>10</td><td bgcolor='#FFFFFF'>=IF(AND(E11<=Between,F11>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project2.c4</td><td bgcolor='#9597D9'>Client4</td><td bgcolor='#9597D9'>2/02/2015</td><td bgcolor='#9597D9'>8/04/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Project1.c5</td><td bgcolor='#FFFFFF'>1/03/2014</td><td bgcolor='#FFFFFF'>31/10/2015</td><td bgcolor='#FFFFFF'>1</td></tr><tr><td>11</td><td bgcolor='#FFFFFF'>=IF(AND(E15<=Between,F15>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project2.c5</td><td bgcolor='#9597D9'>Client5</td><td bgcolor='#9597D9'>17/12/2014</td><td bgcolor='#9597D9'>13/02/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Project2.c3</td><td bgcolor='#FFFFFF'>4/09/2015</td><td bgcolor='#FFFFFF'>5/09/2015</td><td bgcolor='#FFFFFF'>1</td></tr><tr><td>12</td><td bgcolor='#FFFFFF'>=IF(AND(E6<=Between,F6>=Between),1,0)</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#50D092'>Project3.c2</td><td bgcolor='#50D092'>Client2</td><td bgcolor='#50D092'>6/07/2015</td><td bgcolor='#50D092'>21/09/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Project3.c2</td><td bgcolor='#FFFFFF'>6/07/2015</td><td bgcolor='#FFFFFF'>21/09/2015</td><td bgcolor='#FFFFFF'>1</td></tr><tr><td>13</td><td bgcolor='#FFFFFF'>=IF(AND(E9<=Between,F9>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project3.c3</td><td bgcolor='#9597D9'>Client3</td><td bgcolor='#9597D9'>21/11/2015</td><td bgcolor='#9597D9'>26/01/2016</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Project3.c5</td><td bgcolor='#FFFFFF'>13/08/2015</td><td bgcolor='#FFFFFF'>27/09/2015</td><td bgcolor='#FFFFFF'>1</td></tr><tr><td>14</td><td bgcolor='#FFFFFF'>=IF(AND(E12<=Between,F12>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project3.c4</td><td bgcolor='#9597D9'>Client4</td><td bgcolor='#9597D9'>17/07/2015</td><td bgcolor='#9597D9'>4/08/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>Grand Total</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'>5</td></tr><tr><td>15</td><td bgcolor='#FFFFFF'>=IF(AND(E16<=Between,F16>=Between),1,0)</td><td bgcolor='#FFFFFF'>1</td><td bgcolor='#50D092'>Project3.c5</td><td bgcolor='#50D092'>Client5</td><td bgcolor='#50D092'>13/08/2015</td><td bgcolor='#50D092'>27/09/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr><tr><td>16</td><td bgcolor='#FFFFFF'>=IF(AND(E13<=Between,F13>=Between),1,0)</td><td bgcolor='#FFFFFF'>0</td><td bgcolor='#9597D9'>Project4.c4</td><td bgcolor='#9597D9'>Client4</td><td bgcolor='#9597D9'>1/06/2015</td><td bgcolor='#9597D9'>10/07/2015</td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td><td bgcolor='#FFFFFF'></td></tr></table>
Hello,
Not sure this fits your needs. I understood that what you are trying to get is a list of projects that includes the "between date" [current at that date]. So your timeline slicer could generate the value in I2.
In order to achieve that, I added a column B that has the formula display in column A. I used column B:F in my pivot table and filter by inBetween=1. My pivot table is on H5:K14.
It seems to give the right result to my understanding. But it is always hard to guess correctly what a person is trying to achieve.
Hope I am close enough of what you are trying to achieve.
I haven't tested all case of figures

.....