Creating a to-do list using today's date located in multiple columns

[forest1959]

Hi

I'm trying to create a calendar to-do list based on criteria over multiple columns. I have attached a scaled down example of what I have and what I require. the top table is a list of data with scheduled dates included, the bottom one would have todays date and would list which ID numbers had something to do that day

[TABLE="width: 685"]
<tbody>[TR]
[TD][/TD]
[TD]Create drawing[/TD]
[TD]Attend Site[/TD]
[TD]Walkthrough[/TD]
[TD]Snagging[/TD]
[TD]Completion[/TD]
[/TR]
[TR]
[TD]ID1[/TD]
[TD="align: right"]01/11/2017[/TD]
[TD="align: right"]03/11/2017[/TD]
[TD="align: right"]24/11/2017[/TD]
[TD="align: right"]26/11/2017[/TD]
[TD="align: right"]30/11/2017[/TD]
[/TR]
[TR]
[TD]ID2[/TD]
[TD="align: right"]23/11/2017[/TD]
[TD="align: right"]24/11/2017[/TD]
[TD="align: right"]12/12/2017[/TD]
[TD="align: right"]14/12/2017[/TD]
[TD="align: right"]18/12/2017[/TD]
[/TR]
[TR]
[TD]ID3[/TD]
[TD="align: right"]30/10/2017[/TD]
[TD="align: right"]01/11/2017[/TD]
[TD="align: right"]20/11/2017[/TD]
[TD="align: right"]22/11/2017[/TD]
[TD="align: right"]24/11/2017[/TD]
[/TR]
[TR]
[TD]ID4[/TD]
[TD="align: right"]24/11/2017[/TD]
[TD="align: right"]26/11/2017[/TD]
[TD="align: right"]30/11/2017[/TD]
[TD="align: right"]01/12/2017[/TD]
[TD="align: right"]05/12/2017[/TD]
[/TR]
[TR]
[TD]ID5[/TD]
[TD="align: right"]01/11/2017[/TD]
[TD="align: right"]05/11/2017[/TD]
[TD="align: right"]12/11/2017[/TD]
[TD="align: right"]24/11/2017[/TD]
[TD="align: right"]01/12/2017[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24/11/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID1[/TD]
[TD]Walkthrough[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID2[/TD]
[TD]Attend Site[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID3[/TD]
[TD]Completion[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID4[/TD]
[TD]Create Drawing[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID5[/TD]
[TD]Snagging[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Any help would be greatly appreciated.

Regards
Paul

 

[forest1959]

I'm hoping an array formula may do this, but if not, VBA could be an option