| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |
| January | February | March | April | May | June | July | August | September | October | November | December | Month of last Visit | Past Due? | Extention Approved | |
| Tom | May-17 | May-16 | |||||||||||||
| Mike | Nov-17 | Oct-16 | |||||||||||||
| Harry | Aug-17 | Sep-16 | |||||||||||||
| So this may be a bit confusing….. In O3-O5 (Past Due Column), I want it to say "Yes/No", however, I want that to come from the difference between the two dates in row 3 (for "tom", column F and N), N is always the EARLIER date. | |||||||||||||||
| If the difference is 12 months or above, I want it to automatically populate as "Yes" and if it is 11 months or below I want it to populate as "No". | |||||||||||||||
| Since the "newer" date is not always in the same column (month), I need the function to be able to determine the one cell in the row that is populated. There will only ever be one cell populated (from column B-M) for each name. | |||||||||||||||
| Me writing out in words for row 3 is like this, "if the difference between N3 and the cell populated between B3 and M3 is greater than or equal to 12, then YES. If the difference between N3 and the cell populated between B3 and M3 is less than 12, then NO" | |||||||||||||||
| So for Tom and Mike, it should say "Yes", since it has been 12+ months. | |||||||||||||||
| For Harry, it should say "No", since it has only been 11 months. | |||||||||||||||
| I don't know if this is even possible to do but this is hurting my brain. So I need help before I go insane because I will not stop trying/looking for an answer. (I hope this doesn't look awful when posted, can't add gridlines) |
<tbody>
</tbody>
