Spreadsheet: 756490d1637597579-how-to-ignore-calculation-if-cell-within-the-formula-is-blank-deferred-income
Sheet: Nov 21 (2)

Deferred Income Calculation |  |  |  |  |  |  |  |  |  | Totals
 | Period End | 2021-11-30 00:00:00
Organisation | Invoice Date | Invoice Number | Start Date | End Date | Currency | Curr. Value | Inv Value GBP | Days Billed | Daily Value | Days Elapsed | Days Remaining | Deferred Income | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00
Customer 1 | 2021-01-01 00:00:00 | INV-1 | 2020-01-03 00:00:00 | 2022-01-02 00:00:00 | CAD | 8000 | 4588.32
Customer 2 | 2020-01-21 00:00:00 | INV-2 | 2020-01-25 00:00:00 | 2023-01-24 00:00:00 | GBP |  | 20213
Customer 3 | 2020-03-19 00:00:00 | INV-3 | 2021-01-16 00:00:00 | 2023-01-15 00:00:00 | CAD | 20500 | 11988.4
Customer 4 | 2020-05-20 00:00:00 | INV-4 | 2020-07-01 00:00:00 | 2022-06-30 00:00:00 | USD | 3438 | 2546.66
Customer 5 | 2020-05-20 00:00:00 | INV-5 | 2020-07-01 00:00:00 | 2022-08-05 00:00:00 | USD | 27500 | 22457.9
Customer 6 | 2020-06-22 00:00:00 | INV-6 | 2021-05-08 00:00:00 | 2022-05-07 00:00:00 | GBP |  | 10000
Customer 7 | 2020-07-02 00:00:00 | INV-7 | 2021-08-26 00:00:00 | 2022-08-25 00:00:00 | GBP |  | 9000
Customer 8 | 2021-11-02 00:00:00 | INV-8 | 2021-11-14 00:00:00 | 2022-11-13 00:00:00 | GBP |  | 6615
Customer 9 | 2021-11-03 00:00:00 | INV-9 | 2022-01-04 00:00:00 | 2024-01-03 00:00:00 | GBP |  | 8000
Customer 10 | 2021-11-09 00:00:00 | INV-10 | 2021-11-19 00:00:00 | 2022-11-18 00:00:00 | USD | 10500 | 7740.04
Customer 11 | 2021-11-15 00:00:00 | INV-11 | 2022-01-06 00:00:00 | 2023-01-05 00:00:00 | USD | 12000 | 9333.32
Customer 12 | 2021-11-15 00:00:00 | INV-12 | 2021-11-21 00:00:00 | 2024-11-20 00:00:00 | GBP |  | 22000
Customer 13 | 2021-11-15 00:00:00 | INV-13 | 2021-11-26 00:00:00 | 2022-11-25 00:00:00 | GBP |  | 6825
Customer 14 | 2021-11-01 00:00:00 | INV-14 |  |  | EUR | 4000 | 3636.36
Customer 15 | 2021-11-08 00:00:00 | INV-15 |  |  | EUR | 3000 | 2727.27
Customer 16 | 2021-11-09 00:00:00 | INV-16 |  |  | GBP |  | 7000
Customer 17 | 2021-11-15 00:00:00 | INV-17 |  |  | USD | 10000 | 7407.4