Forum Discussion
Calculating cell based on row data
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 |
