Data Extract from 1 Table to another

[Sameer_Kuppanath_Sultan]

Hi All

Happy New Year

I have table 1, contains the data of meals when it starts and ends. 

I want to find the numbers of meals in Table 2 on each date based on Table 1 as per below image by using any formula or VBA

Could any one can help on this issue in Excel

[#2]

@Sameer_Kuppanath_Sultan 

=INDEX($B$6:$D$8,MATCH(B2,$A$6:$A$8,0),MATCH(C2,$B$5:$D$5,0))

Maybe like this.

[#3]

Hi Thanks @OliverScheurich 

I need the formula for below area.