Last business day of month function +1,2,3,4 business days

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

I'm not really clear what you want to do? Do you actually want the last business day of the current month or the first business day of the next month. Using Analysis ToolPak functions you can get the last business day of this month with

=WORKDAY(EOMONTH(TODAY(),0)+1,-1)

or the first business day of the following month with

=WORKDAY(EOMONTH(TODAY(),0),1)

does that help?

Without Using Analysis ToolPak functions try...



=DATE(YEAR(TODAY()),MONTH(TODAY())+1,MIN(0,5-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,6))))


Hope it helps!

What about using this?

=IF(WEEKDAY(A1,2)+1=6,A1+3,IF(WEEKDAY(A1,2)+1=7,A1+2,A1+1))

Where A1 is the last day of the previous month...ie, 10/31/2008