Spreadsheet: 740642d1626434788-display-text-dependent-upon-todays-date-eh_date-return-2-_new
Sheet: Is this how I should do it

 |  |  |  |  |  |  | JANUARY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P1 | 52 | 1 | DELIVERING | P12 | 4 |  |  |  |  | 1 | 2 | 3
 | P1 | 1 | 2 |  | P13 | 1 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | P1 | 2 | 3 |  | P13 | 2 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | P1 | 3 | 4 |  | P13 | 3 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | P2 | 4 | 1 |  | P13 | 4 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  | FEBRUARY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P2 | 5 | 2 | DELIVERING | P1 | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | P2 | 6 | 3 |  | P1 | 2 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | P2 | 7 | 4 |  | P1 | 3 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | P3 | 8 | 1 |  | P1 | 4 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P3 | 9 | 2 | DELIVERING | P2 | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | P3 | 10 | 3 |  | P2 | 2 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | P3 | 11 | 4 |  | P2 | 3 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | P4 | 12 | 1 |  | P2 | 4 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | P4 | 13 | 2 |  | P3 | 1 | 29 | 30 | 31
 |  |  |  |  |  |  | APRIL
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P4 | 13 | 2 | DELIVERING |  | 1 |  |  |  | 1 | 2 | 3 | 4
 | P4 | 14 | 3 |  |  | 2 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | P4 | 15 | 4 |  |  | 3 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | P5 | 16 | 1 |  |  | 4 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  | 17 | 2 |  | P4 | 1 | 26 | 27 | 28 | 29 | 30
 |  |  |  |  |  |  | MAY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 17 | 2 | DELIVERING | P4 | 1 |  |  |  |  |  | 1 | 2
 |  | 18 | 3 |  | P4 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 19 | 4 |  | P4 | 3 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | P6 | 20 | 1 |  | P4 | 4 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | P6 | 21 | 2 |  | P5 | 1 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | P6 | 22 | 3 |  | P5 | 2 | 31
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P6 | 22 | 3 | DELIVERING | P5 | 2 |  | 1 | 2 | 3 | 4 | 5 | 6
 | P6 | 23 | 4 |  | P5 | 3 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | P7 | 24 | 1 |  | P5 | 4 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | P7 | 25 | 2 |  | P6 | 1 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | P7 | 26 | 3 |  | P6 | 2 | 28 | 29 | 30
 |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P7 | 26 | 3 | DELIVERING | P6 | 2 |  |  |  | 1 | 2 | 3 | 4
 | P7 | 27 | 4 |  | P6 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | P8 | 28 | 1 |  | P6 | 4 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | P8 | 29 | 2 |  | P7 | 1 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | P8 | 30 | 3 |  | P7 | 2 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  | AUGUST
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 30 | 3 | DELIVERING |  | 2 |  |  |  |  |  |  | 1
 |  | 31 | 4 |  |  | 3 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | P9 | 32 | 1 |  |  | 4 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  | 33 | 2 |  | P8 | 1 | 16 | 17 | 18 | 19 | 20 | 21 | 22
 |  | 34 | 3 |  |  | 2 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  | 35 | 4 |  |  | 3 | 30 | 31
 |  |  |  |  |  |  | SEPTEMBER
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 35 | 4 | DELIVERING |  | 3 |  |  | 1 | 2 | 3 | 4 | 5
 | P10 | 36 | 1 |  |  | 4 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 37 | 2 |  | P9 | 1 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  | 38 | 3 |  |  | 2 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  | 39 | 4 |  |  | 3 | 27 | 28 | 29 | 30
 |  |  |  |  |  |  | OCTOBER
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 39 | 4 | DELIVERING |  | 3 |  |  |  |  | 1 | 2 | 3
 | P11 | 40 | 1 |  |  | 4 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | P11 | 41 | 2 |  | P10 | 1 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | P11 | 42 | 3 |  | P10 | 2 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | P11 | 43 | 4 |  | P10 | 3 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  | NOVEMBER
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING | P12 | 44 | 1 | DELIVERING |  | 4 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | 45 | 2 |  | P11 | 1 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  | 46 | 3 |  |  | 2 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  | 47 | 4 |  |  | 3 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | P13 | 48 | 1 |  |  | 4 | 29 | 30
 |  |  |  |  |  |  | DECEMBER
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 48 | 1 | DELIVERING |  | 4 |  |  | 1 | 2 | 3 | 4 | 5
 |  | 49 | 2 |  | P12 | 1 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 50 | 3 |  |  | 2 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  | 51 | 4 |  |  | 3 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | P1 | 52 | 1 |  |  | 4 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  | JANUARY
 |  |  |  |  |  |  | Mo | [NAME] | We | Th | Fr | Sa | Su
WORKING |  | 52 | 1 | DELIVERING |  | 4 |  |  |  |  |  | 1 | 2
 |  | 1 | 2 |  | P13 | 1 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 2 | 3 |  |  | 2 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  | 3 | 4 |  |  | 3 | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | P2 | 4 | 1 |  |  | 4 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  | 5 | 2 |  | P1 | 1 | 31
WORKING:
DELIVERING