Hello,
I have a column with YYYYMM in it. I am able to split that column into two columns YYYY and MM. What I am trying to do is figure out what the 5th business day of each month is.
Column C holds the results I am looking for. I want to exclude weekends and holidays from the calculation of 5th business day.
<tbody>
</tbody>
I have a column with YYYYMM in it. I am able to split that column into two columns YYYY and MM. What I am trying to do is figure out what the 5th business day of each month is.
Column C holds the results I am looking for. I want to exclude weekends and holidays from the calculation of 5th business day.
A | B | C | |
1 | 2017 | 09 | 9/8/2017 |
2 | 2017 | 10 | 10/6/2017 |
3 | 2018 | 06 | 6/7/2018 |
4 | 2018 | 07 | 7/9/2018 |
5 | 2018 | 08 | 8/7/2018 |
<tbody>
</tbody>