I am trying to build vb code that will fill in days based upon an input
month and year. For example, if I were to choose September, 2005, a
newly created sheet would fill in the first row as follows:

Sept 1, Sept 2, Sept 5, Sept 6... (excluding 3 & 4 as weekends)

I know I need to write a loop that checks the date and validates it
based upon weekday(excluding if 1 or 7) and stopping if the last day of
the month is reached, but I'm not really sure how to det it up.

Any help would be greatly appreciated.

Thanks,

Jeremy