Vacation calendar

wiwchar

Board Regular
Joined
Sep 11, 2003
Messages
166
I keep track of my employee's vacations on a spreadsheet. At times, I need to update various days where the office is closed. These can be statuatory holidays or company days. Some days the employees vacation allotment is not decremented. These I need to shade the cell with a colour. There are days where the office is closed and all employees need to take a vacation day. In these cells, I would put in a 1 to decrement the vacation days by one. Below is just a part of the spreadsheet. How can this be done rather than manually for each individual employee?
QA Vacation Schedule 2007.xls
ABCDEFGHIJKLMNOPQRST
3EMPLOYEEJANUARYFEBRUARYMARCHAPRIL
4NAME & INFO1815222951219264111825181522
5
6DAYS LEFT AT END OF PREVIOUS YEAR
7M
8Andres, Conrad0T
9VACATION DAYS AT ANNIVERSARYW
10November 24, 2003T
1115F
12ENTITLEMENT
13REMAINING00000000000000000
2007
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

wiwchar

Board Regular
Joined
Sep 11, 2003
Messages
166
Also, let me add some clarification. If Jan 2 is in D8 for Conrad, it will be in D16 for Terry, D24 for Allan and so on.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top