Auto Populate Calendar using list

[ItsGavin]

Hi everyone

I make a monthly roster for my work colleagues. At the moment I am dragging and dropping names and times from a report that is run. I have found a few examples of using a list to auto-populate a calendar, however the issue that I am having is, my workplace's roster month doesn't match up with a calendar month (eg: this month's roster runs from 14 June - 11 July).

Is there a way that I am able to use the calendar similar to the attached but change the months to the roster periods?

Thanks in advance!

[bebo021999]

I think you need 1 more criteria column L for "To"
And a light admendmend in date formula in row 2, 10,...

[ItsGavin]

Wow! Thank you so much! That is exactly what I was after!

Thank you so so much!