HOw do I populate fields with just the workdays?
 

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

HOw do I populate fields with just the workdays?
 

with formulas.
format your date cells to 1/1.
put 1/3/05 in the first date cell. (a1 as example)monday
in the next date cell(b1 as example) put =A1+1 tuesday
in the next date cell(c1 as example) put =b1+1 wensday
in the next date cell(d1 as example) put =c1+1 thursday
in the next date cell(e1 as example) put =d1+3 (skip to
monday)
in the next date cell(f1 as example) put =e1+1
repeat this until all date cell are populate with a formula
you only have to enter a date once. the formula will
calculate all the others. bitch to set up but then you are
set for next week/month/year/decade/century.


-----Original Message-----
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

.