Spreadsheet: 44600d1243371476-nested-if-formula-categorise-dates-into-appropriate-financial-quarter-dummy-wookbook-v2
Sheet: Incidents

 | Incident Details Used for Reports
 | 6 | 2 | 13 | 5 | 2 | 3 | 2A
Department | Accident Code | Date of Accident | Date CF50 Received | Occupation of IP | Location of Incident | Details of Accident & Injuries sustained | Days Lost
Security | 4P | 2009-01-11 00:00:00 |  |  |  |  | 1
Asbestos | 22P | 2009-01-29 00:00:00 |  |  |  |  | 2
Lifts/eng | 2P | 2009-01-21 00:00:00 |  |  |  |  | 2
Lifts/Eng | 28P | 2009-01-23 00:00:00 |  |  |  |  | 5
Flooring | 2P | 2009-01-28 00:00:00 |  |  |  |  | 6
Electrical | 4P | 2009-01-13 00:00:00 |  |  |  |  | 3
Cleaning | 4P | 2009-02-02 00:00:00 |  |  |  |  | 3
Building | 23P | 2009-01-26 00:00:00 |  |  |  |  | 1
Flooring | 22P | 2009-02-10 00:00:00 |  |  |  |  | 1
Cleaning | 8P | 2009-02-06 00:00:00 |  |  |  |  | 1
Security | 4P | 2009-02-13 00:00:00 |  |  |  |  | 3
Cleaning | 28P | 2009-02-23 00:00:00 |  |  |  |  | 2
Building | 18P | 2009-02-18 00:00:00 |  |  |  |  | 1
Building | 4P | 2009-02-16 00:00:00 |  |  |  |  | 2
Lifts/Eng | 8P | 2009-02-26 00:00:00 |  |  |  |  | 2
Flooring | 8P | 2009-02-13 00:00:00 |  |  |  |  | 5
Electrical | 4P | 2009-03-09 00:00:00 |  |  |  |  | 6
Asbestos | 3P | 2009-03-10 00:00:00 |  |  |  |  | 3
Cleaning | 28P | 2009-03-04 00:00:00 |  |  |  |  | 3
Flooring | 6P | 2009-03-09 00:00:00 |  |  |  |  | 1
Flooring | 6P | 2009-03-03 00:00:00 |  |  |  |  | 1
Flooring | 4P | 2009-03-12 00:00:00 |  |  |  |  | 1
Flooring | 28P | 2009-03-18 00:00:00 |  |  |  |  | 3
Electrical | 28P | 2009-03-24 00:00:00 |  |  |  |  | 2
Lifts/Eng | 1P | 2009-03-30 00:00:00 |  |  |  |  | 1
Electrical | 4P | 2009-03-26 00:00:00 |  |  |  |  | 2
Security | 8P | 2009-03-13 00:00:00 |  |  |  |  | 2
Security | 7P | 2009-03-05 00:00:00 |  |  |  |  | 5
Cleaning | 15P | 2008-04-03 00:00:00 |  |  |  |  | 6
Building | 7P | 2008-04-22 00:00:00 |  |  |  |  | 3
Security | 21P | 2008-04-22 00:00:00 |  |  |  |  | 3
Flooring | 22P | 2008-04-30 00:00:00 |  |  |  |  | 1
Cleaning | 12P | 2008-04-24 00:00:00 |  |  |  |  | 1
Cleaning | 5P | 2008-04-30 00:00:00 |  |  |  |  | 1
Cleaning | 21P | 2008-04-03 00:00:00 |  |  |  |  | 3
Heating | 22P | 2008-05-21 00:00:00 |  |  |  |  | 2
Cleaning | 2P | 2008-05-12 00:00:00
Cleaning | 5P | 2008-05-07 00:00:00
Cleaning | 18P | 2008-05-22 00:00:00
Cleaning | 2P | 2008-05-22 00:00:00
Security | 12P | 2008-05-28 00:00:00
Security | 12P | 2008-05-30 00:00:00
Stores | 22P | 2008-06-10 00:00:00
Flooring | 22P | 2008-06-12 00:00:00
Asbestos | 7P | 2008-06-16 00:00:00
Asbestos | 4P | 2008-06-16 00:00:00
Flooring | 4P | 2008-06-16 00:00:00
Cleaning | 2P | 2008-06-18 00:00:00
Flooring | 12P | 2008-06-27 00:00:00
Lifts/Eng | 2P | 2008-06-30 00:00:00
Electrical | 5P | 2008-06-30 00:00:00
Building | 6P | 3rd July 2008
Security | 21P | 2008-07-04 00:00:00
Security | 5P | 2008-07-08 00:00:00
Lifts/Eng | 21P | 2008-07-15 00:00:00
Stores | 2P | 2008-07-22 00:00:00
Electrical | 2P | 2008-07-31 00:00:00
Gas | 6P | 2008-08-07 00:00:00
Gas | 2P | 2008-08-18 00:00:00
Stores | 5P | 2008-08-22 00:00:00
Cleaning | 22p | 2008-08-28 00:00:00
Cleaning | 8P | 2008-09-02 00:00:00
Electrical | 22P | 2008-09-08 00:00:00
Building | 4P | 2008-09-10 00:00:00
Electrical | 15P | 2008-09-10 00:00:00
Security | 5P | 2008-09-13 00:00:00
Lifts/Eng | 22P | 2008-09-16 00:00:00
Cleaning | 27P | 2008-09-15 00:00:00
Electrical | 15P | 2008-09-16 00:00:00
Security | 8P | 2008-09-19 00:00:00
Cleaning | 2P | 2008-09-22 00:00:00
Gas | 12P | 2008-09-24 00:00:00
Heating | 11P | 2008-09-24 00:00:00
Heating | 22P | 2008-09-24 00:00:00
Cleaning | 8P | 2008-09-25 00:00:00
Security | 23P | 2008-10-02 00:00:00
Lifts/Eng | 4P | 2008-10-05 00:00:00
Security | 4P | 2008-10-06 00:00:00
Security | 4P | 2008-10-06 00:00:00
Building | 28P | 2008-10-07 00:00:00
Cleaning | 22P | 2008-10-09 00:00:00
Cleaning | 2P | 2008-10-09 00:00:00
Building | 3P | 2008-10-10 00:00:00
Cleaning | 8P | 2008-10-16 00:00:00
Cleaning | 8PM | 2008-10-17 00:00:00
Cleaning | 22P | 2008-10-20 00:00:00
Asbestos | 5P | 2008-10-28 00:00:00
Cleaning | 5P | 2008-10-30 00:00:00
Building | 12P | 2008-11-03 00:00:00
Building | 10P | 2008-11-12 00:00:00
Security | 21P | 2008-11-04 00:00:00
Cleaning | 6P | 2008-11-01 00:00:00
Heating | 4P | 2008-11-20 00:00:00
Cleaning | 5P | 2008-11-14 00:00:00
Cleaning | 8P | 2008-11-21 00:00:00
Security | 21P | 2008-11-20 00:00:00
Security | 21P | 2008-11-30 00:00:00
Security | 8P | 2008-11-30 00:00:00
Electrical | 15P | 2008-11-28 00:00:00
Electrical | 15P | 2008-11-28 00:00:00
Electrical | 15P | 2008-11-28 00:00:00
Electrical | 15P | 2008-11-28 00:00:00
Cleaning | 9P | 2008-12-02 00:00:00
Cleaning | 9P | 2008-12-02 00:00:00
Cleaning | 4P | 2008-12-03 00:00:00
Cleaning | 4P | 2008-12-09 00:00:00
Cleaning | 2P | 2008-12-11 00:00:00
Lifts/Eng | 2P | 2008-12-18 00:00:00
Lifts/Eng | 22P | 2008-12-18 00:00:00
Security | 21P | 2008-12-19 00:00:00
Lifts/Eng | 4P | 2008-12-31 00:00:00