Spreadsheet for allowing employees to input vacation leave/show employee denial of leave

Welcome to the Forum dZilla.

Yes additional information is good.

To best describe or illustrate your problem you would be better off attaching a "dummy" workbook
without sensitive data. The workbook should contain the same structure and some dummy data of the
same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this
format abc-123 then that should be reflected in the dummy workbook.

Please do not upload pictures. Many of us cannot read them and it saves having to retype data.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in the reply window.

Hope this helps?

I've taken the spreadsheet from something that I've found online, so didn't create it myself.

Essentially I'll be locking the portion where the employee's names & seniority is so that can't be modified.

But I'd like to have it so

That if the top 4 employees request a certain day off, that the 5th employee that requests the day off will be marked on the calendar but marked as denied. And the subsequent one as third denied (with whatever colour coding we decide).

I'd then want a total of employee's that have requested days off that day, and ones that have been denied. Then as shown a tally at the end of the month for the number of days an employee has requested off.

I would then create a new spreadsheet for each month.