Hi,
I have this table below, I need to be able to show the number next observations due for each month (C10:C18)
Thanks Ian
| | A | B | C | D |
| 1 | January | | July | |
| 2 | Febuary | | August | |
| 3 | March | | September | |
| 4 | April | | October | |
| 5 | May | | November | |
| 6 | June | | December | |
| 7 | | | | |
| 8 | | | | |
| 9 | Month Last Observed | current Grade | Next Observation Due | |
| 10 | 20-Apr-21 | Green | Oct | |
| 11 | 27-Apr-21 | Green | Oct | |
| 12 | 21-Jul-21 | Green | Jan | |
| 13 | 15-Jul-21 | Green | Jan | |
| 14 | 19-Oct-21 | Green | Apr | |
| 15 | 27-Jul-21 | Green | Jan | |
| 16 | 11-May-21 | Green | Nov | |
| 17 | 18-May-21 | Green | Nov | |
| 18 | 13-Jul-21 | Green | Jan | |
