Hello,
I have been working on trying to come up with a formula all day and have searched the web and can't find what I need.

For example, I bill customers every three months on the second business day of the month (so not including holidays or weekends). I sent out a bill on 7/5/11 since the first was a friday, the 4th was a holiday that made the 5th of July the "Second Business Day".

I want to create a table that gives me all my future bill dates so I know when to bill going forward, instead of manually having to compute the data. So I billed 7/5/11 and will bill again 10/4/11. I have tried doing a WORKDAY formula, I have tried calculating the days in the month but that always puts me off a day or two randomly and I can't figure out how to get this to work.

I also would like to be able to say in a similar formula that the day should be a Monday. Sort of the same situation as above but if I bill on 7/11/11 I want to bill again 10/10/11. I want that formula to always have the date of a Monday.

Anyone have any clues for either situation?? Let me know if you need more information or anything! Thanks!