Macro to update off days in a tracker

[seemap]

Hello,

i am trying to build a tracker which allows the employee to mark the weekly off of their choice.

Conditions set is 1. Maximum 8 employee allowed to be on off for a particular day. 2. An employee cannot have the same day off for 3 rolling weeks. for ex., if an employee has marked monday as off for week1, he should not be allowed to have the monday off for week 2 and week3, the application should throw an error

Please look into the sample file attached and help me solve the error.

Regards
Seema

[Pash09]

First, I wish to thank you CANAPONE (http://www.excelforum.com/excel-gene...23#post2783323 for guiding me on how to accurately start a new post:

hello I am very new to excel and was just starting: However, I would need to sort out my excel file for my survey result tracker.

I need that on each category, everything i put on a certain date, say, on the 18th, all result on the 18 will be automatically feed on the "daily sheet" under the corresponding dates under the specific ranges:

say: for cat 1, on the 18th of Apr, i need excel to automatically show me the average and total numbers of result gathered on that day.Same as the the Per question daily average. They say sum product is best. I have attached here . April 18 and 19 data have been entered manually.TO EDIT22.xlsx

I desperately need help
Thanks so much

If am still doing this wrong, i apologise