Monthly Calendar using Beginning and End Dates

Hello,

I have a dynamic Monthly calendar that uses some formulas to populate based on the month that is chosen. I originally had this calendar to just look at events that spanned 1 date, so there wasn't a range to look at. Now, my list of events have a start and end date because some go for a month or two and others are just one day. I've tried figuring out how I can adjust the formulas but can't seem to figure it out. Would love if someone could help me with the adjustment or advise me on a better way to go about this all together!

What I would like to show up on the calendar is the Demand Unit, the Sub-Demand Unit and the Action.

(ignore the weekly calendar tab)

Thanks in advance!