Monthly Calendar with Recurring Activities Spanning Several Days

[CarolinaA]

Hi Everyone,
I have been looking through the forum but I can't seem to find an exact answer for this scenario, so I am hoping someone can help me solve this or redirect me to the correct thread if necessary.
I am trying to create a calendar of monthly activities that can be automatically updated by changing the month, but that includes tasks that are recurring and span several days (all the information I found seems to be about having an event on a very specific date, e.g. May 20th, while my events would be from 20 to 25 of every month) and can also overlap (so e.g. an event from 20 to 25 and another from 22 to 30).

I'm attaching an example of what I'm trying to get as a result.


Monthly Calendar - Example.xlsx


Thank you!

[AliGW]

Welcome to the forum.

In B5:

=IF(MONTH(B4)=MONTH(DATEVALUE(Calendar1Month&" 1")),FILTER(Activities[Activities],(Activities[Start Day]<=DAY(B4))*(Activities[End Day]>=DAY(B4))),"")

Copy to all other FIRST cells in the calendar cells. Get rid of your manualy entered results first, though,