Spreadsheet: 76558d1277117448-excel-2007-conditional-formating-other-ways-more-conditions-payroll-timetable-academic-1
Sheet: PAYROLL CALENDAR

 |  | Right Click Insert Date | 2010-06-16 00:00:00
PAY                  PERIOD | Sickness Input | HR Deadline all payroll changes. | Last minute changes deadline | Final payroll calculation agreed | Bacs file sent to Finance | Finance submit bacs | Payslips posted | PAY DATE | GL's emailed to Finance
 | 7 WD Before Bacs | 6 WD before Bacs | 1 WD after HR Deadline | 1 WD before Bacs | 2 WD before Pay Date | 2 WD before Pay Date | 2 WD before Pay Date | LWD of each month. | 2 WD before Pay Date
TIMELINES | COB | COB | DEADLINE |  | COB
 |  |  | BY 12.00PM
Sep
Period 06 | 2010-09-17 00:00:00 | 2010-09-20 00:00:00 | 2010-09-21 00:00:00 | 2010-09-27 00:00:00 | 2010-09-28 00:00:00 | 2010-09-28 00:00:00 | 2010-09-28 00:00:00 | 2010-09-30 00:00:00 | 2010-09-28 00:00:00
October
Period 07 | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | 2010-10-20 00:00:00 | 2010-10-26 00:00:00 | 2010-10-27 00:00:00 | 2010-10-27 00:00:00 | 2010-10-27 00:00:00 | 2010-10-29 00:00:00 | 2010-10-27 00:00:00
November
Period 08 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-26 00:00:00 | 2010-11-26 00:00:00 | 2010-11-30 00:00:00 | 2010-11-26 00:00:00
December
Period 09 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-20 00:00:00 | 2010-12-24 00:00:00 | 2010-12-29 00:00:00 | 2010-12-29 00:00:00 | 2010-12-29 00:00:00 | 2010-12-31 00:00:00 | 2010-12-29 00:00:00
 | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED | TO BE CONFIRMED
January
Period 10 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-27 00:00:00 | 2011-01-27 00:00:00 | 2011-01-31 00:00:00 | 2011-01-27 00:00:00
February
Period 11 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | 2011-02-24 00:00:00 | 2011-02-28 00:00:00 | 2011-02-24 00:00:00
March
Period 12 | 2011-03-18 00:00:00 | 2011-03-21 00:00:00 | 2011-03-22 00:00:00 | 2011-03-28 00:00:00 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 2011-03-31 00:00:00 | 2011-03-29 00:00:00
April
Period 1 | 2011-04-18 00:00:00 | 2011-04-19 00:00:00 | 2011-04-20 00:00:00 | 2011-04-26 00:00:00 | 2011-04-27 00:00:00 | 2011-04-27 00:00:00 | 2011-04-27 00:00:00 | 2011-04-29 00:00:00 | 2011-04-27 00:00:00
May
Period 2 | 2011-05-18 00:00:00 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-26 00:00:00 | 2011-05-27 00:00:00 | 2011-05-27 00:00:00 | 2011-05-27 00:00:00 | 2011-05-31 00:00:00 | 2011-05-27 00:00:00
June
Period 3 | 2011-06-17 00:00:00 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-27 00:00:00 | 2011-06-28 00:00:00 | 2011-06-28 00:00:00 | 2011-06-28 00:00:00 | 2011-06-30 00:00:00 | 2011-06-28 00:00:00
July
Period 4 | 2011-07-18 00:00:00 | 2011-07-19 00:00:00 | 2011-07-20 00:00:00 | 2011-07-26 00:00:00 | 2011-07-27 00:00:00 | 2011-07-27 00:00:00 | 2011-07-27 00:00:00 | 2011-07-29 00:00:00 | 2011-07-27 00:00:00
August
Period 5 | 2011-08-18 00:00:00 | 2011-08-19 00:00:00 | 2011-08-22 00:00:00 | 2011-08-26 00:00:00 | 2011-08-29 00:00:00 | 2011-08-29 00:00:00 | 2011-08-29 00:00:00 | 2011-08-31 00:00:00 | 2011-08-29 00:00:00