On 4 Aug 2005 05:13:38 -0700, "Steve" wrote:

I've had a look at Chip's site and think the answer to my problem will
lie in a Networkdays formula, but don't _know_. So...

Cells A3-A7 are Mon, Tues... Fri
Cell A1 contains the month, B1 the year.

What I want to do is see what day the 1st of the month falls on. I then
want to zero out all days prior to that in column B. From the 1st
onwards, I want to be able to input data.

So, for example, September 05 would look like:

A B
September 2005

Mon 0
Tues 0
Weds 0
Thurs
Fri

If the 1st was a Monday, as it is this month, for example, I would want
all B3-B7 left clear for input.

Does anyone know how I would do this?

Thanks in advance

Steve

I am assuming you wish to put data in column B. If that is the case, you
probably don't want to have formulas in those cells, otherwise you will erase
the formulas when you enter the data.

Perhaps conditional formatting would work for you. You could have the cells
"grayed out" of they precede the first of the month.

With the month and year in A1 and B1; and with the days of the week starting in
Row 3; try the following.

Select B3:B7
From the main menu bar: Format/Conditional Formatting
Formula Is:
=MOD(WEEKDAY(DATEVALUE($A$1&$B$1)),7)(ROW()-1)
Format/Patterns and select some appropriate color (e.g. Grey).

<OK
<OK



--ron