Adding One Month to Date excluding holidays

[Crafty64]

Hi, I'm using the excel function Workday to give me the next business day which allows me to take into account holidays. Lets say as a result of using this function I get a date of 04/08/2011 (mm/dd/yy). My question is how do I increment it by one month to read 05/08/2011 but still allowing me to take into account holidays and non-business days? I can't just extend the number of days in the workday function because of the differing number of days in each month e.g. adding one month to 01/31/2011 I want to see 02/28/2011 (assumming that is a good business day etc). If not I want to look at the next good business day.

Any suggestions?

Thanks

 

[barry houdini]

If you have a date in A1 this formula will add 1 month and then move to the next business day if necessary

=WORKDAY(EDATE(A1,1)-1,1,H$1:H$10)

where you have holiday dates in H1:H10

 

[Crafty64]

Fantastic - thank you!