FYI - I am learning VBA as I go here so keep it simple for me!

I need to generate a range (Column A) of dates based on our sales months under the following conditions. I will bind this to a button: "Generate New Month".
  • The dates cannot be Sundays.
  • The month cannot end on a Saturday or Sunday.
  • The month cannot end on a US holiday.
  • The first day of the newly generated month must start immediately after the previous month ends while still abiding by the rules.

I'm trying to figure it out via formulas first, but I'm sure there's a more efficient way to go about it. In a straight down situation I am using the formula below, but it does not yet account for holidays and more importantly it runs infinitely down. I need to setup my macro to know when to START and when to STOP.

Please Login or Register  to view this content.
Any help is appreciated!