restricted excel rules

[gomaa1239]

Dears,

im trying to make an excel sheet to organize the vacations of my small team, and i dont know how to do the following and i will be so happy of you could help me this time like what you always do

the sheet will be like below
1st column will include the whole days of the year and we can give a maximum number of 3 days as a vacation for each employee so i need a rule to allow each user to put letter (v) _stand for vacation_ only 3 times in his column per each month
if the employee tried to insert the (V) for the 4th time per month he should get an error

date

name1

name2

name3

<tbody>
</tbody>

1/10 v
2/10 v
3/10 v
4/10 v
5/10 v
6/10 v

2) i need to know how to enable excel cell range editing by certin user

Thanks for your support

 

[KenDue]

One idea to get you started: With dates in column A, at the end of each month's rows, place a Total Vac row with the formula =COUNTIF(B3:B32,"v") or whatever number of rows covers the range for that month beneath the first employee's daily cells. Place this conditional format formula =B33>3 in that same cell and format the color of the cell "Red" when condition is met.

Copy the formula across the columns for each employee.

Follow the same procedure for each month.

Hopefully, someone else has an idea for your second need regarding restrictive cell range editing.

 

[FDibbins]

For the 1st part, you could use Data Validation, find it under DATA tab/data Validation, and put something like this in the CUSTOM option...
=COUNTIF($B$2:$B$7,"v")<=3
adjust ranges as needed

for the 2nd part - why would you need anyone to adjust ranges?