I need to calculate the year for the following data. What I want to know for the year column is if there is a date in the Visit date 2018 column bring back 2018 in the year column, if there is a date in the visit date 2019 it will bring back 2019 in the year column, if there is a date in both, it will bring back 2018/2019 in the year column and if there are no dates in either of the visit columns the year column will be blank. I hope that makes sense. Thank you.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Visit Date 2018 | Visit Date 2019 | Year |
3/16/2018 | ||
8/23/2019 | ||
8/23/2019 | ||
8/23/2019 | ||
6/12/2019 | ||
6/12/2019 | ||
6/12/2019 | ||
6/12/2019 | ||
6/12/2019 | ||
1/25/2019 | ||
5/24/2018 | 1/9/2019 | |
7/27/2018 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>