Hi, I would like to know how to calculate the last working day of the designated date after 2 months.
I know it should be =WORKDAY(EOMONTH(A1,2)+1,-1), if A1 is the date.
If I want to include the public holidays as well (let's say range is B1:B10), how do I add this in the formula?
Thank you.