Autofill weekdays/skip weekends in a month

I would like to be able to auto fill weekdays (skipping Saturday & Sunday) in a month. For example, my spreadsheet would look like this if cell A1 contains12/01/09:



DATE WORKDAYS TASK

1-Dec 1 AP CLOSE - CAPITAL & POS ITEMS
1-Dec 1 POS MONTH END
1-Dec 1 HEALTH INSURANCE
2-Dec 2 DEPR SYSTEM RUN; INCL-SOFTWARE AMORT
2-Dec 2 SPECIAL EQUIPMENT
4-Dec 4 PRELIMINARY ENERGY REPORT
7-Dec 5 AP CLOSE - ALL OTHER ITEMS


The DATE column needs to return the date for WORKDAYS listed...Monday through Friday only. The first workday in Dec 2009 is 12/1, the fifth workday is 12/7, and so on...

Thanks!

see NETWORKDAYS function in XL Help, eg

B2: =NETWORKDAYS(EOMONTH(A2,-1)+1,A2,holidays)
copied down

where holidays is a named range containing public holidays to be excluded in addition to weekends - if not required omit.

If you're working the other way around, which in hindsight I think you are, then see WORKDAY function (works along similar lines to above)

A2: =WORKDAY(DATE(2009,12,0),B2,holidays)
copied down

where B2 contains your workday flag - use of named range as before and optional as before