Hi,
I've been trying to look around for anything similar, but I cant find anything at all
I have a list of ranged dates and a value next to them
then a date
for every date I want to check if it falls between any of the ranged dates and to sum every value where it does
This is an example of the structure:
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl64, width: 64"]Start[/TD]
[TD="class: xl64, width: 64"]End[/TD]
[TD="class: xl64, width: 64"]People[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]01/09/2017[/TD]
[TD="class: xl65, align: right"]20/10/2017[/TD]
[TD="class: xl64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]05/09/2017[/TD]
[TD="class: xl65, align: right"]30/11/2017[/TD]
[TD="class: xl64, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
This is what I would expect to return:
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl67, width: 64, align: right"]02/09/2017[/TD]
[TD="class: xl66, width: 64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]07/09/2017[/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]21/10/2017[/TD]
[TD="class: xl66, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
please can you help?
I've been trying to look around for anything similar, but I cant find anything at all
I have a list of ranged dates and a value next to them
then a date
for every date I want to check if it falls between any of the ranged dates and to sum every value where it does
This is an example of the structure:
[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl64, width: 64"]Start[/TD]
[TD="class: xl64, width: 64"]End[/TD]
[TD="class: xl64, width: 64"]People[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]01/09/2017[/TD]
[TD="class: xl65, align: right"]20/10/2017[/TD]
[TD="class: xl64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]05/09/2017[/TD]
[TD="class: xl65, align: right"]30/11/2017[/TD]
[TD="class: xl64, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
This is what I would expect to return:
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl67, width: 64, align: right"]02/09/2017[/TD]
[TD="class: xl66, width: 64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]07/09/2017[/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]21/10/2017[/TD]
[TD="class: xl66, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
please can you help?