2015
Sun Mon Tues Wed Thur Fri Sat Week Weekday
Weekday 1 2 3 4 5 6 7
Week 1 26 Oct 14 OFF ON ON OFF OFF ON ON Date 04 Feb 15 1 4
Week 2 02 Nov 14 ON OFF OFF ON ON OFF OFF

So this is my rotating work schedule, as of right now I could type a date on the right and it will give me the Week # and Weekday # and then I have to look on the chart on the right to see if I'm off or not. I want to make it so that I type in a date and it just automatically tells me "OFF" or "ON." This is driving me nuts, please help!