Spreadsheet: 883807d1732537129-pivot-table-doesnt-recognise-dates-generated-by-a-formula-formula_test-version-4
Sheet: Sheet1

Survey type | Area | Full Address | [NAME] | Phone number | Date helper (hidden) | Survey completed date | Survey AMO | 1st call date | Confirm letter date | No of times appt date changed | Letter 1 alert | Appointment date | AMO | HCS completed? | 2nd call reminder date | 2nd call actual date | Letter 1 confirm letter date | Check 2nd call date (hidden) | Letter 1 suggested appointment date | Letter 1 actual appointment date | L1 AMO | Letter 1 HCS completed? | Letter 2 suggested date | Letter 2 actual date | Letter 2 suggested appointment date | Letter 2 actual appointment date | [NAME] | Letter 2 HCS completed? | Letter 3 suggested date | Letter 3 actual date | Check 3rd appointment (hidden) | Letter 3 suggested appointment date | Letter 3 actual appointment date | L3 AMO | Letter 3 HCS completed? | Survey done (hidden) | Refer to legal date | Referred date
 | Area 1 | 1 High Street | Mr [NAME] | 01234 567890 | 2024-10-14 00:00:00 | 2024-10-14 00:00:00 | [NAME] | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-14 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 2 | 2 High Street | Mr [NAME] | 01234 567890 | 2024-10-14 00:00:00 | 2024-10-14 00:00:00 | [NAME] | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-14 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 2 | 3 High Street | [NAME] | 01234 567890 | 2024-10-14 00:00:00 | 2024-10-14 00:00:00 | Lauren | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-14 00:00:00 | Lauren | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 7 | 4 High Street | Mr Croot | 01234 567890 | 2024-10-20 00:00:00 | 2024-10-20 00:00:00 | Lauren | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-17 00:00:00 | 0 | No | 45583 | 2024-10-19 00:00:00 | 00:00:00 | Completed | 2024-11-01 00:00:00 | 2024-10-20 00:00:00 | Lauren | Yes | Not required | 00:00:00 | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 4 | 5 High Street | Miss [NAME] | 01234 567890 | 2024-11-30 00:00:00 | 2024-11-30 00:00:00 | [NAME] | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-17 00:00:00 | 0 | No | 45583 | 2024-10-19 00:00:00 | 00:00:00 | Completed | 2024-11-01 00:00:00 | 2024-10-20 00:00:00 | 0 | No | 2024-11-29 00:00:00 | 2024-11-29 00:00:00 | 2024-12-13 00:00:00 | 2024-11-30 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 2 | 1 Main Street | Miss [NAME] | 01234 567890 | 2025-01-27 00:00:00 | 2025-01-27 00:00:00 | [NAME] | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-19 00:00:00 | 0 | No | 45586 | 2024-10-22 00:00:00 | 00:00:00 | Completed | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 0 | No | 2024-12-02 00:00:00 | 2024-12-02 00:00:00 | 2024-12-16 00:00:00 | 2024-12-16 00:00:00 | 0 | No | 2025-01-13 00:00:00 | 2025-01-13 00:00:00 | Completed | 2025-01-27 00:00:00 | 2025-01-27 00:00:00 | [NAME] | Yes | Completed | Access gained | 00:00:00
HCS | Area 2 | 2 Main Street | [NAME] | No number | 2024-10-19 00:00:00 | 2024-10-19 00:00:00 | Lauren | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 | 0 |  | 2024-10-19 00:00:00 | Lauren | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
EPC | Area 3 | 6 High Street | 0 | 0 | 2024-11-19 00:00:00 | 2024-11-19 00:00:00 | Lauren | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 | 0 |  | 2024-11-19 00:00:00 | Lauren | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
EPC | Area 6 | 7 High Street | 0 | 0 | 2024-11-22 00:00:00 | 2024-11-22 00:00:00 | [NAME] | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 | 0 |  | 2024-11-22 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HHSRS | Area 2 | 9 High Street | 0 | 0 | 2024-10-23 00:00:00 | 2024-10-23 00:00:00 | [NAME] | 2024-10-12 00:00:00 | 2024-10-12 00:00:00 | 0 |  | 2024-10-23 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00
HCS | Area 5 | 10 High Street | Mr [NAME] | No number | 2024-11-26 00:00:00 | 2024-11-26 00:00:00 | [NAME] | 2024-11-25 00:00:00 | 2024-11-25 00:00:00 | 0 |  | 2024-11-26 00:00:00 | [NAME] | Yes | Not required | 00:00:00 | 00:00:00 | Not required | Not required | 00:00:00 | 0 | 0 |  | 00:00:00 |  | 00:00:00 | 0 | 0 |  | 00:00:00 |  |  | 00:00:00 | 0 | 0 | Completed |  | 00:00:00