employee absence schedule1 template ms office excel 2013

12
 Employee Absence Schedule Tue Wed Thu Fr i Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fr i Sat Sun Mon Tue Wed Thu Fr i Sa t Sun Mon Tue Wed Thu Employee Name  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31  Total Days Employee 1  V V V V V  5 Employee 2  S S P S V V V  7 Employee 3  P S S  3 Employee 4  P V V V  4 Employee 5  S V V S S V  6 January Total 2 2 3 3 1 1 1 1 1 1 2 1 1 1 1 1 1 1 25 Color Key V  Vacation P  Personal S  Sick Custom 1 Custom 2 Dates of Absence January 2013 To add a new employee, select the Total Days cell fo the last employee and then press the Tab key.

Upload: bczarinahhearty

Post on 09-Oct-2015

86 views

Category:

Documents


0 download

DESCRIPTION

Employee Absence Schedule1 Template MS Office Excel 2013

TRANSCRIPT

JanuaryEmployee Absence ScheduleJanuaryDates of Absence2013TueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 1VVVVV5Employee 2SSPSVVV7Employee 3PSS3Employee 4PVVV4Employee 5SVVSSV6January Total002233100010110010121001111010125

Color KeyVVacationPPersonalSSickCustom 1Custom 2

Enter Year:

FebruaryEmployee Absence ScheduleFebruaryDates of Absence2013FriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriEmployee Name1234567891011121314151617181920212223242526272829 Total DaysEmployee 1VVVVV5Employee 2SSPSVVV7Employee 30Employee 4SSPS4Employee 5VVVVS5February Total0021220111201100010100011111021

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

MarchEmployee Absence ScheduleMarchDates of Absence2013FriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50March Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

AprilEmployee Absence ScheduleAprilDates of Absence2013MonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueEmployee Name123456789101112131415161718192021222324252627282930 Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50April Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

MayEmployee Absence ScheduleMayDates of Absence2013WedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50May Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

JuneEmployee Absence ScheduleJuneDates of Absence2013SatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunEmployee Name123456789101112131415161718192021222324252627282930 Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50June Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

JulyEmployee Absence ScheduleJulyDates of Absence2013MonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50July Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

AugustEmployee Absence ScheduleAugustDates of Absence2013ThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50August Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

SeptemberEmployee Absence ScheduleSeptemberDates of Absence2013SunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonEmployee Name123456789101112131415161718192021222324252627282930 Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50September Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

OctoberEmployee Absence ScheduleOctoberDates of Absence2013TueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50October Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

NovemberEmployee Absence ScheduleNovemberDates of Absence2013FriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatEmployee Name123456789101112131415161718192021222324252627282930 Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50November Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2

DecemberEmployee Absence ScheduleDecemberDates of Absence2013SunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueEmployee Name12345678910111213141516171819202122232425262728293031Total DaysEmployee 10Employee 20Employee 30Employee 40Employee 50December Total000000000000000000000000000000

Color KeyVVacationPPersonalSSick0Custom 10Custom 2