Hi all -

This is my first post, and I was wondering if anyone could help me finish this thing out.

I am trying to get my schedule to populate onto a calendar on my second sheet, as you can tell from my work I am very bad at the formulas. I can't get anything to work past the first week. I have marked everything that can happen on what days and how long it lasts, I just need help getting it to populate on the calendar.

I am shooting for something similar to WinCalendar, but I need something that I can manipulate and I don't need a calendar year (just 5-6 months max).

Any and all help is appreciated, and feel free to laugh at my attempt.




Test.xlsx