So Friends,
I need help regarding below table.
I needs "Hours" for respective Resource, basis the current day.
Please note the range of dates extends beyond below table.
I tried doing it by IF function, but it is too complicated for me after 1st/2nd Logic for me.
[TABLE="class: grid, width: 800, align: left"]
<tbody>[TR]
[TD="align: center"]27-Nov-17[/TD]
[TD="align: center"][/TD]
[TD="align: center"]04-Nov-17[/TD]
[TD="align: center"]11-Nov-17[/TD]
[TD="align: center"]18-Nov-17[/TD]
[TD="align: center"]25-Nov-17[/TD]
[TD="align: center"]02-Dec-17[/TD]
[TD="align: center"]09-Dec-17[/TD]
[TD="align: center"]16-Dec-17[/TD]
[TD="align: center"]23-Dec-17[/TD]
[TD="align: center"]30-Dec-17[/TD]
[/TR]
[TR]
[TD="align: center"]Project[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]10-Nov-17[/TD]
[TD="align: center"]17-Nov-17[/TD]
[TD="align: center"]24-Nov-17[/TD]
[TD="align: center"]01-Dec-17[/TD]
[TD="align: center"]08-Dec-17[/TD]
[TD="align: center"]15-Dec-17[/TD]
[TD="align: center"]22-Dec-17[/TD]
[TD="align: center"]29-Dec-17[/TD]
[TD="align: center"]05-Jan-18[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 4[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]40[/TD]
[/TR]
</tbody>[/TABLE]
I need help regarding below table.
I needs "Hours" for respective Resource, basis the current day.
Please note the range of dates extends beyond below table.
I tried doing it by IF function, but it is too complicated for me after 1st/2nd Logic for me.
[TABLE="class: grid, width: 800, align: left"]
<tbody>[TR]
[TD="align: center"]27-Nov-17[/TD]
[TD="align: center"][/TD]
[TD="align: center"]04-Nov-17[/TD]
[TD="align: center"]11-Nov-17[/TD]
[TD="align: center"]18-Nov-17[/TD]
[TD="align: center"]25-Nov-17[/TD]
[TD="align: center"]02-Dec-17[/TD]
[TD="align: center"]09-Dec-17[/TD]
[TD="align: center"]16-Dec-17[/TD]
[TD="align: center"]23-Dec-17[/TD]
[TD="align: center"]30-Dec-17[/TD]
[/TR]
[TR]
[TD="align: center"]Project[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]10-Nov-17[/TD]
[TD="align: center"]17-Nov-17[/TD]
[TD="align: center"]24-Nov-17[/TD]
[TD="align: center"]01-Dec-17[/TD]
[TD="align: center"]08-Dec-17[/TD]
[TD="align: center"]15-Dec-17[/TD]
[TD="align: center"]22-Dec-17[/TD]
[TD="align: center"]29-Dec-17[/TD]
[TD="align: center"]05-Jan-18[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[/TR]
[TR]
[TD="align: center"]Resource 4[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]40[/TD]
[/TR]
</tbody>[/TABLE]