I'm trying to figure out the formula that will give me the last business day of the month plus 1,2,3,4 business days. So if the last day of the month is a wednesday on month A, and the last day of the month is a tuesday on month B, using the logic of that date +1 day would return tue for month A and wed for month B.

Following that, if that last day of month A is a saturday and the last day of month B is a Sunday, the +1 method won't work for saturday because +1 day will return a sunday.

So I believe I need the last day of the month +1,2,3,4 business days. Therefore if the last business day is a friday, and +1 returns a saturday, I believe the best thing to do would be to use a conditional statement to give me the next or +2,3,4 business day of the month. I'm having a hard time figuring out the formula/statement. I hope that makes sense, and as always any help is greatly appreciated.

Cheers