Using Excel 2007... I'm trying to set-up a payment schedule to take a certain dollar figure, divide that up by 12 for a monthly payment, then tie that to a date that is monthly and Mon-Fri and excludes holidays. I have the monthly payment amount taken care of, but I can't get the monthly date part set. I can take the start date and add 30 to it, but then it doubles in a month or two because of the varying number of days in a month. Each month date should also be either the start day of the month or the next business day (if the start day was 15, then each month it should be the 15th or the next business day).

Any help would be appreciated!