Jan 10 2022 09:48 AM
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 |
Jan 10 2022 10:30 AM