Pull project title if it falls between two dates

Hi, 

 

I got this table right here in Sheet1:

A                   B                  C                

Start Date      End Date       Task

15/07/2018    15/07/2018   AAAA

15/07/2018    20/07/2018   BBBB

18/07/2018    20/07/2018    CCCC

 

In SheetB I got a calendar where i want to do the following: 

15/07/2018               16/07/2018            17/07/2018       18/07/2018       19/07/2018

AAAA                           BBBB                     BBBB                BBBB               BBBB

BBBB                                                                               CCCC                CCCC ….etc..

 

So i should get a calendar that tells me what task should be done per date.

Regards,

RAD

By: Rad

Leave a Reply

Your email address will not be published. Required fields are marked *