Making lists from my calendar

Occasional Visitor

Hi,

 

I'm looking for a way to have recurring content in my calendar put into a list.

The list needs to contain the date where the searched content is linked  to.

 

In the attachment you see a part of the calendar. And the box is how I would like it to be displayed. 

I would like to find a formula, so I don't have  to put all in manually.

 

Sincerely,

Stef

1 Reply

@Stef88 

Depends on how you'd like to work with resulting data. As variant

=FILTER(A:B,B:B="day")