On Tue, 4 Jan 2005 10:47:04 -0800, "Arlen"
wrote:

I am creating a spreadsheet to keep track of dentist office productivity. In
one box, I want to allow the user to enter the month and have the workdates
change accordingly. For example, our office works Mondays through Thursdays.
In 2005, the first Monday in January is the 3rd. How could I change the
dates to read 3, 4, 5, 6, then skip to 10, 11, 12, 13, then skip until all
the M-Th of the month are included.

These dates should change if the user types in a different month.

Thank you for your help.

Arlen

If you put some date in the month in A1, then the following formula in A2 will
give the first Monday of that month:

A2: =A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+6)

Then in

A3: =A2+1

and copy/drag to A5 giving

A4: =A3+1
A5: =A4+1

Then in

A6: =IF(ISNUMBER(A2),IF(MONTH(A2+7)=MONTH($A$1),A2+7," "),"")

and copy/drag down to A20


--ron